DINESH REDDY

acw5v4@r.postjobfree.com

937-***-****

TECHNICAL SUMMARY:

• SQL Over 9 plus years of IT experience as a MS SQL Server Developer specializing in database design, development and administration work with SQL Server 2014,2012,2008,2008R2, 2005 for OLTP, OLAP and large-scale data warehouse applications using SSMS.

• Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies

• Development Experience in Data warehouse with Integration Services (SSIS), Analysis services (SSAS) and Report development (SSRS).

• Extensive knowledge and experience in dealing with Relational Database Management Systems (RDMS), Normalized and De-Normalized data models, Star and snow flake schemas

• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.

• Experience in database design features including ER Diagrams, normalization, tables, Temporary tables, constraints, keys, data dictionaries, and data integrity

• Experienced in creating DDL/DML, Triggers, Views, Cursors, Indexes, Derived Tables, User defined data types, Common Table Expressions and T-SQL Programming to maintain efficient data manipulation and consistency.

• Experience in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval

• Proficient in database and data warehouse design and developing ER diagrams logical and physical data modeling and Dimensional Data Models

• Experience in MS SQL Replication, Log Shipping and knowledge of clustering techniques and Database Mirroring.

• Good experience in utilizing Microsoft Power BI tools such as Power View, Power Pivot, Power Query and Power Map to retrieve, analyze and present data in well-designed

• Migrated data from heterogeneous data sources like flat files, MySQL, MS Access, Oracle 9i, and OLE DB sources to various Destinations by using SSIS.

• Experience in performance tuning and query optimization and creating aligned, nonaligned partitions using tools like SQL Server Profiler, Tuning advisor.

• Experienced in creating alerts sql mail agent database mails and scheduled database and DTS packages.

• Expertise in Developing and Extending SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and scripting MDX queries.

• Extensively involved in the SSAS storage and partitions, Aggregate calculations of queries with Multi Dimension Expressions (MDX) for Analysis Services & Reporting Services.

• Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages.

• Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS

Employment History:

Charles Schwab, NC January 2014 – Present

Senior BI Developer

• Designed data models using Erwin data modeler version 9.5.

• Responsible for database design and maintenance.

• Developed SQL scripts to create new tables and views, DML SQL scripts for inserting, updating and deleting data in the new tables.

• Worked on Views, Stored procedures, table valued functions, Triggers.

• Involved with team to optimize database objects like stored procedures, Triggers, Table valued functions and Views.

• Involved in debugging connection related problems, Query Design, Indexing recommendation, Performance Tuning.

• Worked on Complex SSIS packages for Extract Transform and Load Operations from different data SOR (System of Records) with different disparate data sources like Oracle, Teradata, Composite Data source, flat files, Csv files and Excel files.

• Implemented different control flow and Data flow tasks on the extracted data to convert data into required format.

• Developed complex VB.NET Scripts for SSIS packages to incorporate dynamic flexibility.

• Implemented Logging and Package Configurations for all the SSIS packages developed.

• Wrote different expressions for SSIS packages to build source paths, destination paths and names dynamically.

• Experience with Data migration using BCP, importing and exporting from flat files using format files to MS SQL server database.

• Provide production support for CRD, MIDAS applications.

• Implemented Log Shipping using SQL Server 2008 R2 for different production servers.

• Implemented Always On using SQL Server 2012 for different production servers.

• Provide production support for patching, Report validation and Database validations, SSIS daily loads.

• Implemented Error handling and Troubleshooting mechanism using send mail task and log files for Auditing.

• Developed automated Power shell scripts to run ETL deployments, Database backups, evaluate policies on different production servers.

• Developed applications as part of Agile Methodology, working knowledge of all the phases of Agile Methodology.

• Migrated different application databases from 2008 to 2012.

• Working knowledge of Service Broker Architecture as part of MIDAS application.

Environment: Windows 2012, SQL Server 2012, SQL Server Data Tools, Windows XP, MS SQL Server 2005, SQL Server Integration Services 2005, SQL Refactor, BIDS Helper, SQL Data Compare, Microsoft Visual Studio 2005, Team Foundation Server 2010, And SQL Server Reporting Services 2005, C# .Net and VB .Net.

NTT Data Inc. NY January 2012 – December 2014

Senior Consultant

Wholesale Credit Data Integration Reporting

• Responsible for data maintenance.

• Developed SQL scripts to create new tables and views, DML SQL scripts for inserting, updating and deleting data in the new tables.

• Worked on Views, Stored procedures, table valued functions, Triggers.

• Involved with team to optimize database objects like stored procedures, Triggers, Table valued functions and Views.

• Involved in debugging connection related problems, Query Design, Indexing recommendation, Performance Tuning.

• Worked on Complex SSIS packages for Extract Transform and Load Operations from different data SOR (System of Records) with different disparate data sources like Oracle, Teradata, Composite Data source, flat files, Csv files and Excel files.

• Implemented different control flow and Data flow tasks on the extracted data to convert data into required format.

• Developed complex VB.NET Scripts for SSIS packages to incorporate dynamic flexibility.

• Implemented Logging and Package Configurations for all the SSIS packages developed.

• Wrote different expressions for SSIS packages to build source paths, destination paths and names dynamically.

• Developed a package to dynamically download file from SharePoint portal and convert them in to required format using metadata driven tables.

• Experience with Data migration using BCP, importing and exporting from flat files using format files to MS SQL server database.

• Provide production support for the WCDIR application using AUTOSYS 4.5.1 version.

• Provide production support for patching, Report validation and Database validations.

• Implemented Error handling and Troubleshooting mechanism using send mail task and log files for Auditing.

Environment: Windows XP, MS SQL Server 2005, SQL Server Integration Services 2005, SQL Refactor, BIDS Helper, SQL Data Compare, Microsoft Visual Studio 2005, Team Foundation Server 2010, And SQL Server Reporting Services 2005, C# .Net and VB .Net.

CVS Caremark, OH December 2010 – January 2012

Programmer Analyst

Master Benefit Grid, Automated Outbound Messaging, State Extracts (Pharmacy, Claims Extracts), PDE Claims Extract

• Responsible for database design and maintenance.

• Developed SQL scripts to create new tables, stored procedures, table valued functions, triggers and views.

• Developed DML SQL scripts for inserting, updating and deleting data in the new tables.

• Involved with team to optimize database objects like stored procedures, functions, Triggers and Views.

• Involved in debugging connection related problems, Query Design, Indexing recommendation, Performance tuning.

• Installed, deployed and maintained Integration services, Reporting services.

• Developed multiple stand alone packages to Load data from Flat files, Excel files and Source files and automated this process using AUTOMIZE tool to run periodically.

• Developed multiple stand alone packages to Generate Extract files (State Extract, Varolii Extract) and automated this process using AUTOMIZE tool to run periodically.

• Used visual source safe 2005 to keep and maintain our source code.

• Implemented package configurations using SQL Server Tables.

• Implemented Logging in Packages using different Audit Tables and Audit Stored procedures.

• Implemented Error handling and Troubleshooting mechanism using send mail task and log files for Auditing.

Environment: Windows XP, MS SQL Server 2005, SQL Server Integration Services 2005, SQL PROMPT Microsoft Visual Studio 2005, BIDS Helper, and Visual Source Safe 2005, C# .Net and VB .Net.

Member Health LLC,OH June 2010 – December 2010

Programmer Analyst

• Responsible for database design and maintenance.

• Developed SQL scripts to create new tables, stored procedures, table valued functions, triggers and views.

• Developed DML SQL scripts for inserting, updating and deleting data in the new tables.

• Involved with team to optimize database objects like stored procedures, functions, Triggers and Views.

• Involved in debugging connection related problems, Query Design, Indexing recommendation, Performance tuning.

• Installed, Deployed and maintained Integration services, Reporting services.

• Developed multiple stand alone packages to Load data from Flat files, Excel files and Source files and automated this process using AUTOMIZE tool to run periodically.

• Developed multiple stand alone packages to Generate Extract files (State Extract, Varolii Extract) and automated this process using AUTOMIZE tool to run periodically.

• Used visual source safe 2005 to keep and maintain our source code.

• Implemented package configurations using SQL Server Tables.

• Implemented Logging in Packages using different Audit Tables and Audit Stored procedures.

• Implemented Error handling and Troubleshooting mechanism using send mail task and log files for Auditing.

Environment: Windows XP, MS SQL Server 2005, SQL Server Integration Services 2005, SQL PROMPT Microsoft Visual Studio 2005, BIDS Helper, and Visual Source Safe 2005.

SDI Corp, NJ June 2009 – June 2010\

MS SQL Server Developer/BI Developer

• Excellent skills with Installation/Troubleshooting, Managing and Configuration of MS SQL SERVER 2000/2005/2008 on Windows NT/2000/2003/2008 server.

• Excellent skills with Unattended Installation of SQL Server 2005/2008.

• Implemented different types of Replication Models like Snapshot and Transactional.

• Implemented high availability features such as log shipping and database mirroring for large Relational database management systems.

• Experience with Data migration using BCP, importing and exporting data from Oracle, DB2 to MS SQL server database.

• Responsible for database design and maintenance.

• Developed SQL scripts to create new tables and views.

• Developed DML SQL scripts for inserting, updating and deleting data in the new tables.

• Involved with developers team to optimize database objects like SP, Triggers and Views.

• Implemented Cursors to Capture metric data and publish.

• Implemented Performance tuning to improve Performance of the Transact SQL Queries.

• Installed, deployed and maintained Integration services, Reporting services.

• Developed and deployed different types of reports like Parameterized Reports, Linked Reports, Drilldown Reports, Drill through Reports, Snapshot Reports, Cached Reports and Ad hoc Reports.

• Developed Reports using Dundas Reporting Services 2005.

• Developed Dash Board Reports using Center view’s CORDA technology, including Trending Reports, Drill down Reports, and Pie Charts.

• Developed sample Cube for internal purpose using SQL SERVER ANALYSIS SERVICES 2005.

• Installing and Working with Performance Point Server 2007 and Creating Dashboards, Scorecards, KPI.

• Excellent skills with Installation/Troubleshooting, Managing and Configuration of MYSQL Databases on Unix Environment.

• Implemented Replication for MySQL Databases on UNIX Environment.

• Developed code in Dot Net 2.0 framework, C# .Net and VB .Net.

Environment: Windows 2000, Windows 2003 Server, MS SQL Server 2000, MS SQL Server 2005, SQL Server Integration Services 2005 and Reporting Services 2005, Center view Server Corda, Dundas Reporting Tool, MY SQL, C# .Net and VB .Net.

Mindware Global Inc., NJ (Hewlett-Packard) April 2008 – May 2009

MS SQL Server Developer/BI Developer

• Responsible for database design and maintenance.

• Developed SQL scripts to create new tables and views.

• Developed DML SQL scripts for inserting, updating and deleting data in the new tables.

• Involved with team to optimize database objects like SP, Triggers and Views.

• Involved in debugging connection related problems, Query Design, Indexing recommendation.

• Installed, deployed and maintained Integration services, Reporting services.

• Developed Complex SSIS packages for Extract Transform and Load Operations from different data sources, different regions across the world.

• Implemented different control flow and Data flow tasks on the extracted data to convert data into required format.

• Implemented Global configuration mechanism which gives packages a flexibility of Machine Independence.

• Implemented Logging in Packages and processed Log files for improving performance.

• Implemented Defect Tracker mechanism on share point portal to track changes and defects.

• Implemented Error handling and Troubleshooting mechanism using send mail task and log files.

• Automated Complete Business Critical Reporting Project Packages and scheduled using SQL Agent to run at regular intervals of time.

• Developed and Deployed different types of reports like Parameterized Reports, Linked Reports, Drilldown Reports, Snapshot Reports, Cached Reports and Ad hoc Reports and published these reports for business as part of Business Critical Reporting project.

ENVIRONMENT: Windows 2000, Windows 2003 Server, MS SQL Server 2000, MS SQL Server 2005 and 2008, SQL Server Integration Services 2008 and Reporting Services 2008.

Certification:

• Microsoft Certified Technologist Specialist (MCTS) in Implementation, Designing and Maintenance of Databases (70-431)

• Microsoft Certified Technologist Specialist (MCTS) in Microsoft® SQL Server™ 2005 Business Intelligence Development (70-445)

• Microsoft Certified Technologist Specialist (MCTS) in Microsoft® SQL Server™ 2008 Database Development (70-443)

• Microsoft Certified Technologist Specialist (MCTS) in Querying Microsoft SQL Server 2012 (70-461)

Contact this candidate