SUMMARY:

• I have worked in IT industry for over six years, primarily in SQL Server ETL(SSIS), Reports Development (SSRS) and Data Warehousing design and implementation on a wide variety of business applications. My experience has been within the Financial Services and Banking industry, in a number of business areas, including Retail, Institutional Banking, Treasury, and Online Trading. I'm particularly interested in client/server and relational database design using Microsoft SQL Server and C#.Net, SSIS ETL, and reporting using SSRS.
• Good IT experience in Analysis, Design, Development, Implementation, Testing & Support of Data Warehousing and Data Integration Solutions, using Microsoft BI stack (SSIS/SSRS).
• Proficient knowledge in developing SQL with various relational databases like Oracle and SQL Server, complete knowledge on reading and writing T - SQL and PL-SQL queries, including Stored Procedures, UDF and Triggers.
• Has deep understanding about how Microsoft SQL Server works, and rich experience in database design, performance tuning and complex problem troubleshooting.
• Expertise experience in relational database design, data extraction, transformation and writing stored procedures, functions, triggers, from large and complex data sources using Oracle (SQL * Plus, PL/SQL), MS Access and MSSQL Server (SQL, T-SQL).
• Involved in all phases of Software Development Life-Cycle (SDLC) like Agile/Scrum methodologies.
• Adequate experience with dimensional modeling using Star Schema and Snowflake Schema, OLAP/DW, OLTP, Physical and Logical Data Modeling using different data modeling tool Erwin; expertise in design and implementation of various types of Slowly Changing Dimensions (SCD).
• Good understanding of Data Integration patterns, ETL Performance, Parallelism Strategies and Debugging/Troubleshooting performance problems.
• Advanced SSIS concepts of DW package design for Incremental load, Slowly Changing Dimensions.
• Skilled at building and deploying multi-valued parameterized reports including matrixes, charts, and gauges in SSRS.
• Hands on experience on all phases of Software development life cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess 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 pharmaceuticals, outstanding communication and interpersonal skills, ability to learn quickly, good analytic reasoning and high compliance to new technologies and tools.
• Results-Driven with ability to take initiatives and meet deadlines in a fast-paced changing environment; Strong analytical and communication skills with the enthusiasm to learn new technologies.
• Microsoft SQL Server Data Analyst
• Microsoft SQL Server Developer
• Microsoft SSIS ETL Developer

TECHNICAL SKILLS:

Database: Microsoft SQL Server 2008R 2/2012/2014/2016

SQL, T: SQL, .NET/C#, Python, HTML5/CSS, JavaScript

MS BI Stack: SSIS, SSRS, SSMS

Tools: Utilities Visual Studio 2012/2013/2015

PROFESSIONAL EXPERIENCE:

Confidential, Mahwah, NJ

BI Developer

• 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.
• Working as one of the primary T-SQL Developers in the team to design and develop SQL Server 2014 Databases, Tables, Indexes, Stored procedures, UDF, Views, 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, Sybase), 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.
• Analyzed and Developed Complex Stored Procedures, Functions, Index, Triggers, Cursor, Table, Constraints, Joins, Subquery and CTE in SQL to facilitate efficient data manipulation and data consistency.
• Wrote and maintained database documentation, including data standards, procedures, definitions for the data dictionary and logical and physical models of the databases.

Confidential, New York, NY

Microsoft SQL Server BI Developer

• Written complex SQL statements using joins, sub queries, correlated sub queries and CTE.
• Designed, deployed, and maintained various SSRS Reports in SQL Server 2008R2.
• Designed, modified database objects such as tables, views, indexes, Stored Procedures, user defined data types and functions.
• Used various SSIS/ETL tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Responsible for creating reports based on the requirements using SSRS 2008.
• Wrote ad-hoc T-SQL queries for data analyzing, research, unit testing and identifying and resolving bugs.
• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Involved in unit testing against the developed packages and reports.
• Analyzed and documented the legacy SQL Database for performances tuning.
• Wrote production implementation documents and provided Production support when required.

Confidential, MI

Data Analyst

• 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.