add photo
Reddy
bsnr58@hotmail.com
832-545-3346
Houston TX
Houston Heights, TX 77008
Lead Programer
17 years experience
0
Recommendations
Average rating
182
Profile views
Summary

  • Ten plus years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Financial, and Telecom Sectors.
  • Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
  • Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling
  • Expertise in working with relational databases such as Oracle, SQL Server, MS Access and Teradata.
  • Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica and SSIS as ETL tools on Oracle, SQL Server, Teradata Databases.
  • Experience in Error handling, Debugging, error logging for production support in SSIS.
  • Experienced in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
  • SQL Server 2008/2005/2000 OLAP database development including KPIs, Data mining, working with changing dimensions.
  • Performed Logging and Deployment of various packages in SSIS.
  • Experienced in enhancing and deploying the SSIS Packages from development server to production server.
  • ETL implementation using SQL Server Integration Services SSIS, Reporting Services SSRS
  • Strong ASP.NET, VB.NET knowledge.
  • Developing reports on SSRS, Tableau, and QlikView
  • Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, and Oracle PL/SQL.
  • Created stored procedure for generating reports using SQL Server Reporting Services SSRS
  • Implemented parameterized, cascading parameterized, drill-down, drill-through and sub-reports using SSRS.
  • Experienced in administrating the created reports and assigning permission to the valid users for executing the reports.
  • Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
  • Worked on OLAP Data warehouse, Model, Design, and Implementation.
  • Logical Data Modeling, Data warehouse design concepts, Dimensional Modeling using Star, Snowflake, Normalized and De-normalized Schemas with respect to query and analysis requirements.
  • Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services SSAS
  • Experienced in Creating and Updating Statistics to improve the SQL Server Performance.
  • Experienced in managing Data and Transaction log files, Files Groups.
  • Experienced in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys
  • Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
  • Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
  • Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
  • Good Experience in SAS/BASE, SAS/Access, SAS/ SQL

Experience
Education
Skills
Windows
2021
13
ADO.NET
2021
11
ASP.NET
2021
11
MS Visio
2021
11
VB.NET
2021
11
HTML
2021
10
Java
2021
10
SQL
2021
10
Oracle
2015
8
SQL Server
2015
8
SSIS
2015
8
SSRS
2015
8
Stored Procedure
2015
8
T-SQL
2015
8
Triggers
2015
8
WebServices
2015
8
XML
2015
8
JavaScript
2015
7
XSL
2014
7
Crystal Reports
2015
1
SSAS
2015
1