SUMMARY:

• Overall 10 years of IT experience as MS SQL Server Developer 2016/2012/2008 R 2/2008/2005/2000, Business Objects 6.x/ XI R2 (Designer, Desktop Intelligence, Web Intelligence, Info View, Central Management Console & Broadcast Agent) in various Industry verticals like Healthcare, Insurance, Finance, Banking.
• Highly proficient in the use of T - SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, Relational Database models, Data integrity.
• Expert in Creating, Configuring and Fine-tuning ETL workflows for Homogenous and Heterogeneous Systems using DTS, SSIS of MS SQL Server 2008/2012/2016 and SQL Server .
• Excellent in developing SSIS packages to Extract, Transform, Load (ETL) data into Data Warehouse from source databases such as Flat File, Excel, CSV, MS Access .
• Expert in Performance Tuning and Query Optimization.
• Implemented complicated transformations to be used in SSIS packages.
• Expert in Data mart modeling, Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2012/2008/2005 (SSRS).
• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server Performance.
• Perform admin job, server set up, Data Migration in Dev, Test and Production environments.
• Experience in using Team Foundation Server (TFS).
• Maintained positive communications and working relationships at all business levels.
• Has expertise in Requirements gathering and writing functional and technical specifications for developing Crystal Reports.
• Has good experience in Business Objects XI R2/R3 (CMC, CCM, Desk I, Web I), Designer, Infoview and Import Wizard and Crystal Report Version 11.0(XI).
• Expert in E-R diagrams, universe design, Star and Snow Flake Schema for data warehouse.
• Practiced in clarifying business requirements, performing gap analysis and designing process and system improvements to increase productivity and reduce costs.

TECHNICAL SKILLS:

MS SQL Server 2012/2008 R 2/2008/2005/2000 /7.0, MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), MS SQL Analysis Services(SSAS), Microsoft Access 2000/8.0, Microsoft Excel, Outlook, MS SQL Profiler, SQL Query Analyzer, Database engine tuning advisor, JIRA, C#, Toad, Erwin Data Modeler 7.2/4.2/4.1, Crystal Reports 8.5, T-SQL, Business Object XI R2, BO Designer, Desk I, Web I, Info view, UNIX, Windows 2003/2000 Advanced Server/Professional, Windows NT 4.0 Server/Workstation.

PROFESSIONAL EXPERIENCE:

Confidential, East Rutherford, NJ

Sr. Sql developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, and Views.
• Applied various business logic to scrub/clean/validate/convert/allocate the data using string manipulations, analytical functions, cast functions, CTE, user defined functions, and ad-hoc queries.
• Creating data sheets for cleansing Finance, marketing by brand using product hierarchy rules, Manufacturing, Transportation, Customer and Purchasing by extracting data from JDE system using mapping document.
• Successfully implemented indexes on tables for optimum performance.
• Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases.
• Worked with Oracle JDE Server to extract, cleanse and load information by domain needs.
• Extracted data from various files using SQL server log providers like text file, SQL server database, trace file, xml file to load in the SQL server database.
• Involved in writing procedures and Scheduling the Jobs in Sql server using SQL server Agent.

Tools: & Technologies: MS SQL Server 2016, Windows 2013, OLAP, OLTP, T-SQL, C#, Query Analyzer, MS Office 2013, JDE, Team Foundation Server (TFS).

Confidential, Lyons, NJ

Sr. Sql developer /SSRS developer/ SSIS developer

Responsibilities:

• Experienced in writing complex SQL queries, Stored Procedures, Triggers, Views, DML, DDL and user defined functions to implement business logic and also created clustered and non-clustered indexes
• Involved in creating database objects - Tables, Indexes, Views, User defined functions, Cursors, Triggers, Parameterized Stored Procedures, Constraints and Roles.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, XML Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and have experience in Incremental data loading.
• Created the automated processes for SSIS Packages run sequentially using SQL Server Agent job.
• Experience in report customization via the use of Grouping, Sorting, Field Highlighting, Conditional Formatting, Running Totals, Summaries, Static & Dynamic Parameters, Custom Formulas and Custom Functions.
• Experience in creating Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS and SharePoint point Using Report builder.
• Used SQL Server Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Worked closely with Business People for gathering business requirements for the reports, data load processes and for the Cubes development. Actively involved in Production Support and on-call support for every release on behalf of Database team.
• Responsible for administration of external and intranet patient data entry based on ASP/IIS5 and SQL Server.
• Provide application support to users of pharmacy call center Administrators ASP/ASP.NET.

Tools: & Technologies: MS SQL Server 2016/2014/ 2008, SSIS/SSAS/SSRS, T-SQL, SQL Server Profiler, SQL Server Agent, Erwin Data Modeler, SQL Server Management Studio, ASP.net, IIS, TFS.

Confidential, Jersey City, NJ

Sr. Sql Developer/SSIS Developer/SSRS Developer

Responsibilities:

• Designed SSIS ETL packages to validate, extract, load from different file formats and a data source.
• Reviewed incoming data structures and business definitions and usage.
• Used sequence containers, loop containers, Script task, execute SQL task and various data flow tasks.
• Performed data migration from source databases to data warehouse with incremental load using SSIS.
• Creating Database Backup strategy (Full backup, Differential backup and Transaction log back up) and disaster recovery procedures.
• Implementing SQL server high availability tools like Replication, Log shipping, and database mirroring.
• Wrote complex SQL queries involving multiple tables using Joins, sub-queries, temporary tables.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012.
• Created Stored Procedures, User Defined Functions to facilitate data load.
• Responsible for identifying sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions).
• Generated reports of types drill down, drill through, adhoc, matrix, and parameterized reports using SSRS.
• Developed many Tabular Reports, Matrix Reports, Sub Reports, dynamic grouping, drill down Reports and Charts using SQL Server Reporting Services (SSRS 2008).
• Used Team Foundation Server to create interactive reports with an ability to drill down into details.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Configured Email Alerts for unsuccessful completion of Scheduled Jobs.
• Gathered Business requirements for Integration points and mapped them with Functional requirements.

Tools: & Technologies: MS SQL Server 2012, Windows 2000/NT/XP, SSIS, SSRS, OLAP, OLTP, T-SQL, C#, Query Analyzer, MS Office 2003, Oracle 9i/10g, Erwin 4.0, Team Foundation Server (TFS).

Confidential, New York, NY

Sr.Sql Developer/SSIS Developer/SSRS Developer

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification. Participated in implementing the logical design to the physical design by creating tables.
• Involved in the data mart design.
• Created new schema, new tables, field definitions and mappings, stored procedures, views, indexes following the Normalization standards to maintain data consistency.
• Created SSIS Packages by using transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate) and also used Custom components such as Audit on Pre-Execute, Audit On Post-Execute, Custom Email Task.
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop to loop over a Directory to load inbound files coming daily.
• Tested, Cleaned and Standardized Data to meet the business standards using Fuzzy and Exact lookups.
• Connected SSIS projects to Team Foundation Server and updating the packages.
• Configured the loading of data into slowly changing dimensions.
• Responsible for creating the reports based on the requirements using SSRS 2008.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Created different type of reports which include: Cross-tab, Conditional, Sub report, Drill-down and Parameterized dynamic reports and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Deployed and upload the SSRS reports to SharePoint Server for the end users and Involved in Enhancements and modifications.

Tools: & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Oracle 11g, ODBC, Crystal Reports 2008, Microsoft Excel.

Confidential, New York, NY

Sr. Sql developer/SSIS Developer/SSRS Developer

Responsibilities:

• Designed SSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access, DB2 and transform and load into Dimension and Fact tables in Data Warehouse using SSIS.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Extensively used SSIS transformations like Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created Schema Objects such as tables, views, maintained referential integrity and granted roles to the Users.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Wrote Stored Procedures and triggers to capture inserted, deleted and updated data from OLTP systems.
• Used Team Foundation Server to retain Project code during deployment process.
• I nteract with the Enterprise Data Warehouse team to facilitate and document the data mapping to the Reporting SQL Server environment.
• Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports.
• Provided design, implementation and maintenance for custom reports and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS.
• Create parameterized reports in SSRS for a more dynamic presentation of the data.
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2008.

Tools: & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, Erwin 7.2, Microsoft Access, Oracle 10g

Confidential, Bloomington, IL

Senior MS SQL Server/SSIS/SSRS Developer/Data modeler

Responsibilities:

• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Responsible for creating database objects using T-SQL 2008 to store data and to maintain database efficiently.
• Used ETL to implement the SCD transformation, to maintain historical data in data warehouse. Applied various transformations like Data Conversion, Multicast, Conditional Split, Derived column in SSIS.
• Developed and deployed packages using SSIS 2008/2005, also maintained the jobs running on Servers.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.
• Responsible for implementation of SSIS Logging, error configurations for error handling the packages.
• Deploying, Testing and Scheduling SSIS packages using SQL Agent.
• Successfully tested and stored all history versions of TSQL codes, SSIS Packages as well as reports using Team Foundation Server.
• Created many Cascaded parameters for generating dynamic reports using SQL SSRS 2012/2008.
• Highly involved in automating reports generated weekly and monthly basis for the client and business sales teams.
• Scheduled report execution and delivery and tracked reporting history.
• Worked with production control team to deploy code and for schedule run in both staging while testing and production.

Tools: & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Win 2003 Advanced Server, Erwin 7.2

Confidential, Charlotte, NC

Crystal Report Developer/BO Developer/MS SQL Server Developer /SSIS developer

Responsibilities:

• Gathered data, Planned, Defined and Designed data based on business requirement and provided documentation for further reference.
• Designed Database using Erwin data modeler.
• Reviewed the conceptual EDW (Enterprise Data Warehouse) data model with business users.
• Developed SSIS Packages using Lookup Values, Fuzzy Look Up and Fuzzy Grouping for data cleansing and implementing rules provided by Business in the mapping document.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the SSIS packages, which were developed to update the database on Daily basis.
• Created the Load packages for loading the CSV files from DB2 into SQL Server using SSIS 2008.
• Created new Business Objects instances.
• Developed Web I report for various business needs.
• Developing several complex reports, sub reports using various features like (multiple grouping, drill down, parameterized fields, formulas and conditional formatting tuning the existing Crystal XI reports.

Tools: & Technologies: MS SQL Server 2008, T-SQL, SSIS, Win 2003 Advanced Server, Erwin 7.2, Business object XI R2, Crystal Reports 2008.

Confidential

MS SQL Server Developer/Crystal Report Developer

Responsibilities:

• Designed and modeled Microsoft SQL Server 2005 and modified the existing Microsoft SQL Server 2000 data warehouse and data marts.
• Developed database objects such as Tables, Triggers, Stored procedure and Indexes using T-SQL.
• Perform T-SQL tuning and optimizing queries for Reports, which take longer, time in execution SQL Server 2005.
• Involved in Database design using SQL Server 2012, and applying Team Foundation Service for versioning.
• Designed a universe using alias and contexts as per the report requirement.
• Involved in creating and publishing reports on the web using the Info View in Web Intelligence.
• Created various complex reports using drill down/up, slice and dice, breaks, filters and alerts.
• Resolved loops using contexts, aliases and integrity check.
• Created Classes and Objects taking the information from the database. Also created measure objects.
• Created Complex & Multi-Dimensional reports, Master/Detail and Sub Queries in Crystal .
• Created Details, Summary, Cross-tab reports using filters, Sorting, Groupings based on Crystal fields.
• Exported the universes to the Repository to make the resources available to the users.
• Validated the data of reports by writing SQL queries in T-SQL Developer against ODS.
• Formatting reports, generated charts as per user requirements.
• Gathered requirements through meetings and existing documentation.

Tools: & Technologies: MS SQL Server 2000/2005, Windows 2003, Crystal Reports 11.0, TFS, Business Objects XI R2, Oracle 10g, and Windows Xp.