SUMMARY

• Proficient knowledge in developing SQL with various relational databases SQL Server, complete knowledge on reading and writing T - SQL queries, including Stored Procedures, UDF and Triggers.
• Deep understanding about Microsoft SQL Server, and rich experience in database design, performance tuning and complex problem troubleshooting. Adequate experience with dimensional modeling using Star Schema and Snowflake Schema, OLAP/DW, OLTP, Physical and Logical Data Modeling using Erwin;
• Good IT experience in Analyzing, Designing, Developing, Implementing, Testing & Supporting of Data Warehousing and Data Integration Solutions, using Microsoft BI stack (SSIS/SSRS) and Python.
• Expertise in design and implementation of various types of Slowly Changing Dimensions (SCD). Advanced SSIS concepts of DW package design for Incremental load and SCD.
• Expertise experience in relational database design and ETL. Good understanding of Data Integration patterns, ETL Performance, Parallelism Strategies and Debugging/Troubleshooting performance problems.
• Skilled at building and deploying multi-valued parameterized reports including matrixes, charts, and gauges in SSRS. Extensive experience in Tableau Story and Dashboard design.
• Involved in all phases of Software Development Life-Cycle (SDLC) like Agile/Scrum methodologies including requirement gathering from business users, analysis, design, and creation of mapping documents, specification writing, development, testing etc.
• Coding experience with Python to implement crawling, pre-processing and other repetitive tasks.
• Understand the business rules based on High Level document specifications and implement the data transformation methodologies. Ability to meet deadlines and multi-tasking, decisive with strong leadership qualities, flexible in work schedules, excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.
• Strong business understanding of financial institutes and pharmaceutical companies, outstanding communication and interpersonal skills, ability to learn quickly, good analytic reasoning and high compliance to new technologies and tools.

TECHNICAL SKILLS:

DATABASE: Microsoft SQL Server 2012/2014/2016

ETL TOOL: SSIS

DATA VISUALIZATION: SSRS, Tableau, Excel

PROGRAMMING: T-SQL, Python, C/C++/C#, Java

DEVELOPMENT: Agile/Scrum, JIRA, SVN, Git/Github, Visual Studio 2013/2015/2017, Anaconda

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

Senior Microsoft SQL Developer

Responsibilities:

• Worked with Client/Business Analysts to define data requirements for reporting warehouse system import data feeds. Responsible for identifying and translate business requirements for the Enterprise Data Warehouse into logical and physical data models.
• Involved in all phases of Software Development Life-Cycle (SDLC) by using Agile/Scrum methodologies in the current development activities.
• Took the lead to enhance team development practices on SQL Server Data Tools, Visual Studio and Team Foundation Services.
• Active participation in technical investigations and prototyping of various Data Warehouse projects based on MS BI stack.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.
• Working as one of the primary T-SQL Developers in the team to design and develop SQL Server 2012/2014 Databases, Tables, Indexes, Stored procedures, UDF, Views, and Triggers.
• Performed database management, design performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, Extended Events, SQL Analyzer, and SQL Enterprise Manager.
• Created SSIS Packages using Control flow task, Execute SQL task, Data Flow task, Script task, Container, Precedence Constraints and Expressions, Data Profiling task, Data Flow Transforms, Data Conversion, Derived Column, Conditional split, union all, Merge Join, Sort, Aggregate, Pivot Transformation, Fuzzy Lookup, Term Lookup according to the business requirements.
• Worked with heterogeneous sources such as flat files and relational sources (Oracle, DB2), developed packages to pull data from heterogeneous sources, transform the data according to the business requirement and load into the destination SQL Server 2014 tables.
• Implemented the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Administered, monitored and supported SSIS Packages and ETL process. Wrote support documentation for SSIS packages/SSRS reports and Stored procedures
• Created different types of Tabular, Matrix, Drill-Down, Cascaded parameterized, Chart report and Sub reports in multiple formats using SSRS.
• Designed and Implemented Dashboard using Tableau, possess good understanding of Tableau Server and Tableau Report Publishing to AWS.
• Performed various data analysis using Python, extensive usage of Pandas and numpy library.

Confidential, Cleveland, OH

Senior Microsoft SSIS Developer

Responsibilities:

• Contributed in the database design and implementation for the client multi-tier web solution.
• Designed, created and regular tuned of physical database objects (tables, views, indexes) in MS SQL Server 2012 to support normalized and dimensional models.
• Designed the packages in order to extract data from SQL database, flat files and loaded into Databases.
• Designed ETL packages dealing with different data sources (SQL Server, Oracle, Flat Files, and Excels etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Optimized existing database solution by reviewing performance issues, streamlining overnight data process, migrating DTS packages to SSIS, and improving SQL queries, stored procedures, SSIS packages, and reports to dramatically improve customer experience.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Developed SSRS reports. Optimized SQL queries for processing huge result sets by rewriting the queries, implementing table-valued functions or stored procedures.
• Worked with T-SQL to create tables, views, and stored procedures. Performed database management, performance tuning and issue tracking by using SQL Server Management Studio and SQL Server Profiler.
• Experience in creating multiple reports in Drill mode using tables, financial tables, crosses tabs, charts.
• Developed Tableau Dashboards to allow Interactive Data Viewing.
• Wrote stored procedures for the purpose of loading data-mart tables. Architected business transformation layer in SQL Server to facilitate reporting.
• Provided data services to the support team (data scrubbing, inserting and updating customer data).
• Python coding to implement certain pre-processing task, extensive usage of requests library, and file system.

Confidential, Chicago, IL

Microsoft SQL Server SQL Developer

Responsibilities:

• Worked as a developer in creating Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created and managed schema objects such as Tables, Views, Clusters, Indexes, Procedures, and Triggers and maintained Referential Integrity.
• Monitored the daily SQL jobs, SQL Server error logs and Windows error logs.
• Assemble and convert user requirements into standard reporting solution and customize specific user requests when necessary.
• Done Database refreshment from development to production environment.
• Designed, developed and maintained data driven systems as needed within the company ranging from sales data warehouses to desktop databases and web front ends.
• Investigate and optimize reporting system performance by optimizing queries, and using report cache and snapshot.
• Manage and maintain stored procedures and standard reports; build reports from Analysis Services cube using MDX query designer.
• Schedule and manage daily/ weekly/monthly sales and operational reports based on the business requirements.
• Responsible for 24X7 on-call rotation.