PROFESSIONAL SUMMARY:

• Excellent backend skills in creating SQL objects such as Tables, Complex Stored Procedures, Effective Functions, Views, Indexes, Triggers, Rules and SQL Performance Tuning to facilitate efficient data manipulation and consistency.
• Strong experience in client interaction and understanding business applications, Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Technical experience with design and hands - on programming on diverse technology platforms including RDBMS, Cube design & development, ETL engines, BI Scorecards and dashboards.
• Experience in Project Management and Software Development lifecycle including analysis of business function, software design, specifications and software development, testing and documentation, and planning for redesign or transition to another platform.
• Experience with Business Intelligence Development Studio (BIDS)
• Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS).
• Proficient in Resolving Complex Issues and Error Handling in SSIS
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS and SSIS Packages.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Good understanding of SQL Server Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS:

Platforms: Windows (2000,XP,Vista,7,8,10), MS SQL Server 2012/2008 R2/2008/2005, ORACLE, MS Access, MySQL

Languages: T-SQL, XML, Visual Basic, Java

Applications / BI Tools: Microsoft Data Transformation Services (DTS), SQL Server Integration (SSIS), SQL Server Reporting (SSRS), SQL Server Analysis (SSAS), PowerPivot, Cognos, ER Studio, SQL Server Business Intelligence Development Studio (BIDS), MS Access, SQL SERVER, Crystal Report 9.0, MS Project, MS Visio

Work Flow Tools: MS Visio, SharePoint

Miscellaneous: Visible Analysis and Troubleshooting

PROFESSIONAL EXPERIENCE:

Confidential

Senior SQL Server Developer

Key Responsibilities:

• Worked on all activities related to the development, implementation, administration and support of ETL processes
• Created multiple Requirement Documents.
• Coded fixes and enhancements to Existing tables and packages.
• Used hard coding vs SSIS components like Transformations, Merges, Condition Split, Term extraction, Aggregations, Multicasting in packages.
• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.
• Contributed to the design and modification of SSIS Packages.
• Created complex views, stored procedures and function.
• Enhanced performance using optimization techniques-normalization and indexing
• Performance tuning of Queries and Stored Procedures.
• Performance tuning on existing ETL packages.
• Created triggers and countless dynamic coding using both SSMS and MS Excel
• Wrote and maintained system documentation.

Environment: SQL Server 2012, MS Excel, Visual Basic, Data Tools, BO

SQL Server SSIS/SSRS ETL Developer

Key Responsibilities:

• Worked on all activities related to the development, implementation, administration and support of ETL processes
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases
• Used advanced SSIS tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance
• Enhanced performance using optimization techniques-normalization and indexing
• Performance tuning of Queries and Stored Procedures.
• Performance tuning on existing ETL packages.
• Designed various SSRS reports as requested by the client
• Created and developed Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Created Dashboards, Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Applied security to reports on item and folder level.
• Utilized triggers, linked servers, dynamic coding and job processing
• Wrote and maintained system documentation.

Environment: SQL Server 2008 R2, SQL Server 2012, MS Excel, Visual Basic, BIDS,

SQL Server SSIS/SSRS/SSAS ETL Developer

Key Responsibilities:

• Full Performance, Development and QA environments including security, data generation, performance statistics, and backup/restore using SQL Litespeed, in addition to version control and connection configuration for nearly 300 database instances ranging in size from 90 GB to 600 GB
• Development for Reporting team involving coding, security, code reviews, metadata implementation, and replication troubleshooting
• Performed capacity planning and growth prediction for government and client audit data
• Generated optimizations to replace import processes, DTS and cursors with procs, looping and SSIS, decreasing average job run from 5 hours to 25 minutes
• Query tuning based on query execution plans, statistics, and profiling
• Created code based solution for application error involving composite key manipulation
• Coded optimization objects including hierarchical flattening functions, strategic indexes, and staging tables as well as data and file partitioning
• Utilized triggers, linked servers, dynamic coding, job processing and bitwise operation in order to create a GSA audit solution.
• Coordinated and set up new development environment using scrub copies of production data
• Administered version control of development projects using Rational ClearCase
• Worked with development teams in the design of physical databases and in modification.
• Created Tabular, Matrix reports (crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Worked with Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Proficient in SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
• Designed SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Generated and Deployed ETL SSIS packages both design and code to process data to target databases.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance
• Created XML schemas to update user tables and system objects for company data dictionary.

Environment: SQL Server 2008/2008 R2, Visual studio 2005/2008, Microsoft Access, Informatica, BIDS, UltiPro, SAS

Confidential

Software Engineer

Key Responsibilities:

• Served Project Lead and team member in the completion of 20+ medium- to large-scale implementations, managing projects from business requirements analysis to solutions delivery and support.
• Researched, planned, installed, configured and at times created software interfaces.
• Involved in creating new databases, performance tuning, deploying, scheduling and creating reports. This included ETL of data from flat file and excel sources using SSIS, writing T-SQL backup and create various operational, drill-through and dynamic reports using SSRS.
• Integrated, tested and supported Remedy, a third party Asset Management and Ticketing application by fully understanding the system requirements.
• Enhanced performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Organized and Communicated with clients via face-to-face meetings, conference calls.
• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis.
• Followed Data Management processes and procedures to meet system audits and provided input to the creation of data definitions, business rules and data access methods.
• Worked as a team member with other technical staff, such as networking to ensure connectivity and compatibility between systems.
• Wrote and maintained system documentation.
• Developed and tested storage strategies and disaster-recovery plans.
• Enhanced end users’ understanding of database systems by conducting pre-implementation workshops and creating user-friendly training materials.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Rendered reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis and managed subscriptions.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.

Environment: SQL Server 2008, SQL Server 2008 R2, MS Excel, Erwin, Visual Basic, BIDS, Cognos