PROFESSIONAL SUMMARY:

• Over 7 years of strong experience in the IT industry as a MS SQL Server 2014/2012/2008 R2/2008 Developer/MSBI Developer/ (ETL) SSIS /Report (SSRS) Developer in financial, insurance (P&C) domains.
• Excellent technical and analytical skills with strong understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services.
• Proficient in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, Data Integrity, SQL join, CTE and Query Writing.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules.
• Extensive working experience of (ETL) in usage of SSIS Control Flow elements, data flow elements and multiple transformations provided by SSIS such as Data Conversion, Fuzzy lookup, Fuzzy grouping, slowly changing dimension, conditional split, derived column transformations.
• Expertise in enhancing and deploying SSIS (ETL batches) Packages from development server to Testing server or production server.
• Experience in providing Logging, Error handling by using Event Handler, and Performance Tuning in SSIS (ETL) packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Proficient experience in working on conceptual, physical and logical data model using Data Modeling tools like Erwin.
• Expertise in problem resolving and root cause analysis if technical issues along with recommending and implementing best business techniques.
• Strong knowledge of Agile methodology, data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Worked extensively in Query Optimization and Performance Tuning using tools SQL Profiler.

TECHNICAL SKILLS:

Database: MS-SQL Server 2014/12/08-R2, OLAP, OLTP, Oracle, My SQL 6.0, Microsoft Access, Microsoft ExcelETL/ Business Intelligence Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Management Studio, Business Intelligence Development Studio (BIDS), Tableau Desktop 9/8, Tableau Server, QlikSense 3.0

Data Modeling Tools: Erwin 7.2, MS Visual Studio 2010/2008, MS Office, Visio 2010/2007/2003.

Languages/ Scripting: T-SQL, PL-SQL, HTML, VB.NET, C, C++, C#.

Other: Microsoft Office, Visual Basic 6.0, Microsoft Project, JIRA, SharePoint, TFS.

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

SQL Server/SSIS (ETL)/SSRS Developer

Responsibilities:

• Conducted detailed analysis of each Legacy source system interface with Data warehouse (DW) including all existing Mainframe Files and Data elements to be converted from Source system to Target Pre-staging.
• Worked with Project Manager and Business Analyst to understand business requirement and involved in planning, defining and designing data based on business requirements.
• Worked with data modeling product support team on tool features, functionality and maintenance.
• Designed and developed SSIS (ETL) batches for loading data from OLTP system, DSR (Staging Database) to DW.
• Responsible for creating database objects like Table, Store Procedure, Triggers, Functions, CTE etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Developed Package Configuration by using SQL Server type for making Package dynamic.
• Modified the Existing SSIS (ETL) Packages and added more audits and alerts in case of package failure.
• Created Views to reduce complexity of end user and created Index to optimize performance of TSQL queries.
• Created complex SSIS packages using C# in script task as per the requirement.
• Involved in scheduling job using SQL Server Agent for SSIS Packages and Store Procedure as per requirement.
• Responsible for deploying (ETL) SSIS Packages to testing server and Troubleshooting for any error occurs in execution.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Created parameterized, Drill down and Drill through reports in MS SQL environment using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and representatives for various business needs using Subscription in SQL Server Reporting services (SSRS).
• Created different kind of reports such a Parameterized Reports, Sub Reports, Charts, Matrix reports, Linked reports.
• Created documents for all Store Procedure, SSIS Package and SSRS Reports have been developed.

Environment: MS SQL Server 2014 Enterprise Edition, SQL Server Integration Service, SQL Server Reporting Services, SSAS, OLAP, Visual Studio, T-SQL, Enterprise manager, MS-Access, MS Excel, Erwin Windows XP Professional, SQL server Profiler.

Confidential, Jersey City, NJ

MSBI /ETL (SSRS/SSRS) Report Developer

Responsibilities:

• Involved in designing queries and store procedure, UDF and views in SQL Server management studio.
• Used Joins, CTE, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Designed SSIS (ETL) Packages to transfer data from various sources such as Text Files, XML Files, SQL Server, Excel and Access to SQL Data Tools.
• Optimized queries using Database Engine Tuning Advisor and SQL Profiler.
• Worked with different control flow items like Execute Package, Execute SQL, Send mail and Bulk Insert tasks.
• Responsible for using various transformation such as derived column, union all, conditional split, audit, script, lookup, SCD, row count, fuzzy lookup and fuzzy grouping in SSIS ETL packages.
• Responsible for creating SSIS (ETL) packages to load data to dimension and fact tables in SQL Server data warehouse (EDW).
• Created configuration files and enabling logging and error handling in SSIS ETL, and using user defined variables to dynamically configure packages during runtime in SSIS.
• Created SSIS packages using C# and VB.NET in script task as per the requirement
• Built packages and handled slow changing dimensions to maintain the historic data.
• Involved in unit testing of SSIS packages and used to fix defects in packages.
• Used best business practices for performance tuning of SSIS (ETL) packages.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Used cascading parameters to generate a report from two different data sets in SSRS.
• Created dynamic reports using SSRS, generated report models using report builder for the end users.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Created reports to retrieve data using Stored Procedures that accept parameters. Developed reports of Fixed Income securities trading and processing for bank management.
• Responsible for giving user access and setting restrictions to view the reports.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS object.

Environment: Microsoft SQL Server 2012 Enterprise edition, SSMS, SSIS, SSRS, BIDS, Microsoft Visual studio 2012/2010, Windows server 2008, MS SQL Profiler, TFS 2010, XML, Excel

Confidential, Purchase, NY

SQL Server/SSIS (ETL)/SSRS Developer

Responsibilities:

• Worked with Project Manager and Business Analyst to understand business requirement and involved in planning, defining and designing data based on business requirements.
• Involved in translating business requirements into technical specification document and database diagrams.
• Reviewing and re-writing/re-building TSQL codes, SSIS (ETL) packages and SSRS reports for performance improvement and logging in SQL Server 2012.
• Created various SQL objects such as schema, tables, field definitions and mappings, stored procedures, CTE, Triggers, views and indexes/keys.
• Involved in performance tuning of DW and troubleshooting T-SQL queries issues.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Created packages to validate, extract, transform and load data to a centralized SQL server data warehouse using OLEDB providers from the existing diversified data sources.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers. Also in creating SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
• Involved in unit testing of SSIS (ETL) packages and used to fix defects in packages.
• Enforced data consistency by adding data viewer to the transformations and created dynamic packages by using variables to store the data into SQL.
• Responsible for Creating, Scheduling and publishing reports using SSRS, Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Supported production operation activities, with focus on integration and development of new and existing products and services.

Environment: MS SQL Server 2012, BIDS, Visual Studio, T-SQL, SSIS, SSRS, Win 2003 Advanced Server, Erwin v7.2, TFS 2010, XML, Oracle.

Confidential, Harrisburg, PA

SQL developer/SSIS/SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of the data source and data flows.
• Designed SSIS Packages (ETL) to transfer data from various sources such as Text Files, XML Files, SQL Server, Excel and Access into data mart.
• Involved in troubleshoot and problem solve SQL database issues.
• Optimized queries using Database Engine Tuning Advisor and SQL Profiler.
• Worked with different SSIS control flow items like Execute Package, Execute SQL, Send mail and Bulk Insert tasks.
• Extensively used derived column, union all, conditional split, audit, script, lookup, SCD, row count, fuzzy lookup and fuzzy grouping transformations in SSIS packages.
• Responsible for creating SSIS packages to load data to dimension and fact tables in SQL Server data mart.
• Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.
• Built packages and handled slow changing dimensions to maintain the historic data.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Involved in creating various reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascading parameters to generate a report from two different data sets in SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and representatives for various business needs using Subscription in SQL Server Reporting services (SSRS).

Environment: Microsoft SQL Server 2008 R2/2008, SSMS, BIDS, SSRS, SSIS, SSAS, Oracle 10g, XML, Windows server 2008, visual studio.

Confidential

Jr. MS SQL Server Developer

Responsibilities:

• Used Joins, correlated and non-correlated sub-queries for complex business queries involving.
• Multiple tables & calculations from different databases.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Created configuration files, enabling logging and error handling in SSIS, and using user defined variables to dynamically configure packages during runtime in SSIS ETL process.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Participated in the business requirement review discussions to understand the project scope.

Environment: : Microsoft SQL Server 2008, SSMS, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, Visual Studio.