SUMMARY:

• Highly adaptable and experienced Microsoft SQL Database Developer with a proven track record of high client satisfaction. Adept at adapting work pace to evolving client deadlines.
• Skilled in a number of BI technologies including SQL Server 2012/2014 Reporting Services, Integration Services and T - SQL. Well versed in data warehousing methodologies. Can add value rapidly by integrating well with co-workers and quickly gaining relevant business knowledge.
• Highly motivated SQL Server Developer with seven years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2008R2/2012/2014, SSIS and SSRS.
• Strong experience developing SSIS ETL process for a Data Warehouse using Microsoft SQL Server 2012/2014.
• Solid hands-on skills in design and development of data movements using SQL Server Integration Services (SSIS), TSQL and Stored Procedures.
• Strong understanding of data warehouse and ETL concepts and best practices such as Kimball Methodology, Dimensional Model, Slowly Changing Dimensions, Surrogate Keys, Star Schema and Snowflake Schema.
• In-depth knowledge of complex Transact-SQL. Power user of advanced SQL queries with multi-table joins, group functions, subqueries, set operations, view, triggers, UDF and stored procedure.
• Experience in troubleshooting problematic queries/packages through multiple diagnostic tools including using DMV/DMOs, SQL profiler, Extended Events and performance reports. Good at adding indexes, devising and implementing new solutions to enhance the performance.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle/DB2, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge Join, Lookup, Fuzzy Lookup, Slowing Changing Dimension, CDC Incremental Load, etc.
• First hands-on skills in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Strong SQL Query performance tuning skills for complex queries, procedure and indexing strategies by using various tools such as execution plan, table statistics, SQL hint, SQL trace, SQL Server Profiler and Extended Events.
• Good understanding in data warehousing design and implementation, including Kimball methodology, data modeling, normalization and de-normalization, conformed facts & dimensions design, slowly changing dimensions, surrogate keys, star/snowflake schema.
• Expert in creating and deploying reports & dashboards with all kinds of features like using cascading parameters, drill-down and drill-through, parameterized reports, templates, data-driven mode using SSRS, Power View and Power Pivot.
• Extensive knowledge of Agile/Scrum software development methodology by using JIRA/Rally and version control tools such as SVN, Git and Github.
• Proven ability to approach and solve problems effectively and independently; Experience to manage multiple priorities and handle multiple tasks.
• Excellent English writing, verbal and communication skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

TECHNICAL SKILLS:

DATABASE:: Microsoft SQL Server 2008R 2/2012/2014/2016, Oracle 11g/12c, MySQL, Access

MS BI STACK:: SSIS, SSRS, SSAS, SSMS

LANGUAGE:: T-SQL, C/C++/C#/.NET, PowerShell, Bash, Perl, Java, SAS, R, Python

DEVOPS:: Agile/Scrum Methodology, JIRA/RALLY, SVN/Git/Github, Visual Studio 2012/2013/2015

PLATFORM:: Windows Server 2008/2012/2012 R2, Redhat Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Lincoln, RI

Senior Microsoft SQL Server SSIS and SQL Developer

• Effectively managed day-to-day tasks / activities in coordination with a team of developers to effectively meet the deliverables and schedule of a data solution component within a larger application project.
• Used Agile/Scrum methodology to complete each task on its complexity level and worked on Sprint methodology.
• Collaborated with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
• Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files, Oracle etc. to SQL Server using SSIS various features such as multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion.
• Scheduled jobs to execute SSIS packages, which were developed to update database objects daily and maintained nightly loads of data by creating the corresponding tasks.
• Performed tune to optimize SQL queries using SQL profiler and query analyzer. Involved in performance tuning of the database and T-SQL queries using Explain Plan. Created Indexes, Constraints and Rules on database objects.
• Developed cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes, dimension members, calculation, actions, partitions and perspective using SQL Server Analysis Services 212 to analyze data based on sales information.
• Worked on Sev1, Sev2 Issues and also providing 24x7 On-Call Support and provided on-call and day-to-day support.

Confidential, Franklin Lakes, NJ

Senior Microsoft SQL Server Developer

• Designed, developed and delivered / implemented data solutions including architecture design, prototyping of concepts to proof of concept, development of standards, design and development of test plans, code and module design.
• Developed and tested data solution, provided debugging, design and implementation of a solution that follows efficient design techniques and development that meets and exceeds the intent of the design of the data solution.
• Collaborated with IT operations and testing organizations to ensure timely releases of projects and make sure database environments are sustainable.
• Responsible to write very complex database queries, designed various SQL objects and applied performance tuning to enhance the accuracy of the data. Responsible for designing reports using SSRS.
• Assembled and converted user requirements from multiple clients into our standard reporting solution (SSRS 2012) and customized specific client requests when necessary.
• Created SSIS packages to export and import data from Oracle, CSV files, Text files and Excel spreadsheet. Involved in installation, configuration and developing of SSIS packages using BIDS.
• Generated variety of business reports using SQL Server 2008 SSRS including matrix report, parameter report, and dashboard with charts and drill down function.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting. Tested and analyzed relational and OLAP data. Enforced different business constrains and rules using triggers and check constraint.
• Created Complex SQL queries, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF).
• Performed T-SQL tuning and optimization of queries that take longer execution time using MS SQL Profiler, Indexes and Execution plans in MS SQL Server 2008R2.

Microsoft BI Developer (SSRS/SSIS)

• Partnered with program manager to identify requirements, identify and evaluate alternatives, and implement solutions.
• Architect, design, and develop data models, multi-dimensional schemas and SSRS reporting systems for internal partners based on business requirements.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Used SSIS Packages for importing and exporting the data from various databases to excel, XML and flat files by making use of BCP, Bulk Insert.
• Developed enterprise KPI’s into Dashboards - Summery with Details for Accounting, Marketing, Scheduling
• Planed, Analyzed, Designed, Developed, Implemented, Maintained, and Controlled Application Databases for online channels / Equipment Inventory and Maintenance.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Involved in VB and C# coding for the customization of the SSIS packages.
• Using SQL Server Analysis services 2012 created & enhanced Cubes, Dimensions, Measures based on the business requirement.
• Using Dimension Creation wizard created Standard Dimensions with attributes, relationships, Levels and hierarchies and tested using Dimensions browsers.

Saint Paul, MN P

Microsoft SQL Server Developer

• Consulted with the business to determine logical design for new business solutions.
• Designed ER diagrams and mapped the data into database objects and involved in normalization of the database in OLTP.
• Wrote T-SQL scripts to validate and correct inconsistent data in the staging database before loading data into database. Converted various SQL statements into Stored Procedures thereby reducing the number of database accesses.
• Generated variety of business reports using SQL Server 2008 SSRS including matrix report, parameter report, and dashboard with charts and drill down function.
• Performed data extraction, transformation and loading (ETL) between Oracle and MS SQL Server databases using SSIS.
• Used customer requirements to improve functionality (speed, performance / usability) by writing tons of T-SQL code.
• Followed data standards, resolved data issues, completed unit testing and system documentation for ETL processes.
• Conducted system tests, troubleshoot customer issues and corrected database defects.
• Participated in special projects as needed and performs other duties as assigned.
• Created and implemented Test cases for the mappings developed and then created integration Testing Document.