Uploaded File
add photo
Reddy
bsnr58@hotmail.com
832-545-3346
Houston TX
Houston Heights, TX 77008
Lead Programer
15 years experience
0
Recommendations
Average rating
108
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
Lead Programer
Information Technology
Aug 2015 - present
  • Understanding Customer requirement via interaction and writing functional specification
  • Involved in the System study and Database Design using MS SQL Server.
  • Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
  • Implemented and enhanced existing reports like Group By, Drilldown, Drill Through Sub-reports, List, Tabular matrix navigation reports, standard parameter and cascading Parameter Multivalve Parameters
  • Created numerous Dashboard Reports (Metrics) for different business modules
  • Experience in Data Warehouse data and dimensional modeling, Business Intelligence and ETL design and development.
  • Designing and developing OLAP dimensions, cubes, measures, and calculated members with SQL Server /Analysis Services.
  • Designing and developing Tableau/ SSRS reports using SQL retrieving data.
  • SQL Server Index Maintenance Performance Tuning for Large Tables
  • Designed and populated reporting tables, views and stored procedures
  • Transferred data from various data sources/business systems including Oracle, DB2, Teradata, Flat Files to SQL Server using SSIS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
  • Participating in defining ETL strategies, preparing transformation rules and mapping data from source to target
  • Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Developed, monitored and deployed SSIS packages.
  • Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Implemented security to restrict the access to users and to allow them to use only certain reports.
  • Developed DSV (Data Source Views) from Fact and Dimension Tables and Created Dimensional Modeling by using Star & Snowflake Schema
  • Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
  • Environment: VB.NET, ASP.NET, ADO.NET, HTML, SQL Server 2005/ 2008/2012, SSRS, SSIS, VSS 2005, Acrobat Professional 8, MS Office 2000, MS Visio 2002, Java Script, Web Services, Windows XP/2000/NT.
ASP.NET Java VB.NET ADO.NET HTML MS Visio SQL Windows
Remove Skill
Senior Programmer
Professional/Consulting Services
May 2014 - Aug 2015
  • Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
  • Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction ,data load and transformations
  • Created various database objects such as tables, indexes and views based on the requirement.
  • Dynamically supported business users for given requirements and developed the reports accordingly.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
  • Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
  • Created checkpoints and configuration files in SSIS packages
  • Experienced in slowly changing dimension in SSIS packages.
  • Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
  • Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
  • Created data sources, connection strings and defined the datasets for generating the report.
  • Designed and written the queries in the query builder for retrieving the data
  • Created and worked with drill down reports and identified the report parameters.
  • Used various report items like tables, sub report and charts to develop the reports in SSRS.
  • Deployed and generated reports on to the server using the Reporting Services Report Manager.
  • Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
  • Created subscriptions to provide a daily basis reports.
  • Managed and troubleshoot report server related issues.
  • Migrated some Crystal reports to SSRS reports.
  • Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending
  • OLAP Cubes, Dimensions and data source views.
  • Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
  • Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
  • Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS utility and ETL tools such as SQL Server integration Services( SSIS)
  • Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
  • Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Environment: VB.NET, ASP.NET, ADO.NET, HTML, SQL Server 2005/ 2008/2012, SSRS, SSIS, VSS 2005, Acrobat Professional 8, MS Office 2000, MS Visio 2002, Java Script, Web Services, Windows XP/2000/NT.
VB.NET ASP.NET WebServices ADO.NET HTML JavaScript MS Visio SQL Crystal Reports Java Oracle SQL Server SSAS SSIS SSRS Stored Procedure T-SQL Triggers XML Windows
Remove Skill
Senior Programmer
Professional/Consulting Services
Oct 2007 - May 2014
  • Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
  • Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction data load and transformations
  • Created various database objects such as tables, indexes and views based on the requirement.
  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
  • Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
  • Created checkpoints and configuration files in SSIS packages
  • Created data sources, connection strings and defined the datasets for generating the report.
  • Designed and written the queries in the query builder for retrieving the data.
  • Created and worked with drill down reports and identified the report parameters.
  • Used various report items like tables, sub report and charts to develop the reports in SSRS.
  • Deployed and generated reports on to the server using the Reporting Services Report Manager.
  • Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules
  • Created subscriptions to provide a daily basis reports. Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
  • Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
  • Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP, DTS utility and ETL tools such as SQL Server integration Services( SSIS)
  • Creating user logins and adding users to respective databases.
  • Created SSIS package to uploaded data to the warehouse, once the data is verified.
  • Generated stats based on the uploaded data and existing data to check the data accuracy and export them to excel for distribution.
  • Created web services to return list of suppliers and customers.
  • Created Quality Assurance stats reports using SSRS
  • Managing security tasks like granting and revoking Permissions
  • Created new database objects like Functions, Packages, Triggers, Indexes
  • Environment: VB.NET, ASP.NET 2.0, ADO.NET, VS 2005, XML, XSL, XPATH, HTML 4.0, SQL Server 2005, SSRS, SSIS, VSS 2005, MS Office 2000, MS Visio 2002, Java Script, Web Services, Windows XP/2000/NT.
VB.NET Java JavaScript ASP.NET WebServices HTML MS Visio SQL ADO.NET Oracle SQL Server SSIS SSRS Stored Procedure T-SQL Triggers XML XSL Windows
Remove Skill
Senior Programmer
Professional/Consulting Services
Jan 2007 - Sep 2007
  • Developed complex T-SQL code for the application.
  • Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, views and other SQL joins and statements for applications.
  • Designed and implemented the stored procedures and triggers for automating tasks.
  • Developed SQL Server Stored procedures and DTS packages to extract data from database.
  • Implemented constraints on tables.
  • Created SSIS Packages to migrate slowly changing dimensions
  • Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server
  • Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Wrote queries to produce reports using SQL Server 2000/2005 Analysis Services (SSAS) and Reporting service (SSRS).
  • Environment: VB.NET, ASP.NET 2.0, ADO.NET, VS 2005, XML, XSL, XPATH, HTML 4.0, SQL Server 2005,SSRS,SSIS, VSS 2005, MS Office 2000, MS Visio 2002, Java Script, Web Services, Windows XP/2000/NT.
ASP.NET VB.NET WebServices MS Visio ADO.NET Java JavaScript SQL SQL Server SSIS SSRS Stored Procedure T-SQL Triggers XML XSL Windows
Remove Skill
Edit Skills
Non-cloudteam Skill
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