SUMMARY:

• Highly motivated SQL server developer with eight years of IT experience in database and business intelligence technologies with expertise on ETL process and Reporting using SQL Server 2012/2008 R2/2005/2000, SSIS and SSRS.
• Strong experience with T - SQL(DDL & DML) in implementing and developing stored procedures, triggers, nested queries, joins, cursors, views, user defined functions, indexes, user profiles, relational database models,
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Experience in error handling and debugging coding issues and troubleshooting production issues.
• Expertise in SQL Server 2012/2008 R2/2005 Reporting Services (SSRS), SQL Server 2012/2008 R2/2005 Integration Services (SSIS) and in SQL Server 2008 R2/2005 Analysis Services (SSAS) in Business Intelligence (BI).
• Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2012/2008 R2/2005).
• Excellent knowledge of scheduling jobs and alerts using SQL Server Agent.
• Experience developing Dashboard, Ad-hoc and Parameterized Reports, creating complex reports (ex: drill down reports using different objects) using SSRS.
• Experience Configuring and maintaining Report Manager and Report Server for SSRS. Deployed and Scheduled the Reports in Report Manager.
• Integration of SSRS Reports using various web parts into SharePoint (MOSS 2007) and various delivery mechanisms.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using SQL Server Analysis Services.
• Good understanding of Normalization /De-normalization, Normal Forms and database design methodology. Skilled in design of logical and physical data modeling using Erwin data modeling tool.
• Ability to work in all stages of system development life cycle (SDLC).
• Conversant in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Worked with Business Analysts, Web development team, and users on Microsoft Business Intelligence solutions.
• Strong leadership, communication, problem-solving and multi-tasking abilities.

TECHNICAL SKILLS:

Tools: & Packages: SQL Server Management studio, Enterprise Manager, SQL Profiler, SQL

Server Business Intelligent: studio (BIDS), DTS, Report Builder 9.0, HP QC, SharePoint 2007, Team Foundation Server, JIRA, HP QC

BI Tools: SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services.

Databases: MS SQL Server 2012/2008 R2/2005/2000, MS Access 97/2003/2005/2008.

Language: T-SQL, PL/SQL, .NET

Operating Systems: Windows XP/7/10, Windows Server 2000/2003/2008/2012, UNIX.

Application Packages: MS Office Suite, MS Outlook.

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Bridgewater, NJ

Senior SQL, PL/SQL Developer

Responsibilities:

• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Strong experience in Data warehouse concepts, ETL.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Developed materialized views for data replication in distributed environments.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.

Environment: SQL Server 2005/2008 R2/2012 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, Visual Studio 2008 & 2010, MS Visio 2010,Team Foundation Server.

Confidential, Neenah, WI

Sr. SQL Server Developer

Responsibilities:

• Actively participated in Investors Data related meetings with users, team lead and project manager to fully understand the requirements of the system
• Responsible for extracting data from multiple claims such as Legacy claims, Policy claims and assemble them into meaningful business intelligence.
• Converted legacy Data Transformation Services (DTS) packages to SQL Server Integrated Services (SSIS) packages.
• Worked in importing/exporting data from different sources like Oracle/Access/Excel/XML to SQL Server destination using SSIS.
• Used various SSIS transformations such as Conditional Split, Derived Column which were used for data scrubbing, data validation checks in staging database before loading the data into the data warehouse.
• Used various SSIS tasks like Bulk Insert Task, FTP Task, Script Task, Send Mail Task etc.,
• Used Execute Process Task with WinSCP for implementing the functionality to download files from SFTP Server.
• Create and maintain data flow diagrams for existing and future ETL processes and creating mapping document with detailed source-to-target ETL mapping specifications.
• Developed ETL audit process and controls to ensure data quality is compliant with defined standards and thresholds.
• Enhancing and deploying the SSIS packages from development server to production server.
• Experience in creating parameterized reports and linked reports with thorough knowledge of reporting service architecture. (Table, chart and matrix report).
• Created and Deployed SSRS Reports using BIDS.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Evaluate alternate solutions and design processes and systems which include user impact considerations, cost and benefit analysis, and processing specifications.
• Developed SQL Server stored procedures, functions, and database views.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Generated power view reports in Excel 2013 for the users to as per user requirements along with BA.
• Strong RDBMS concepts and experience in creating, maintaining and tuning Views, Stored Procedures User Defined Functions and System Functions using SQL Server, T-SQL.
• Worked in the information support and the productions support areas actively.
• Scheduling request to create a new job, new scheduling groups & bouncing the Control-M agents, changes in the schedules.
• Co-ordinate with functional & DBA team to STOP and START the applications during the maintenance or Migration.
• Good Experience in scheduling the Jobs to balance the workload.

Environment: SQL Server 2005/2008 R2/2012 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, Visual Studio 2008 & 2010, MS Visio 2010,Team Foundation Server.

Confidential, Newark, NJ

Sr. SQL Server Developer

Responsibilities:

• Used SSIS to create ETL packages (.DTSX files) to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Enhanced and deployed the SSIS Packages from development server to production server.
• Wrote the ETL scripts to load the data into database from various source files. Implemented error handling and troubleshoot the scripts that fail to load the data into database.
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Created SSIS packages to retrieve data from legacy sources and also to retrieve PII user data from the flat files on monthly and weekly basis.
• Integrate SQL Server 2008 R2 reporting services with Microsoft Share Point Portal Server to deliver automatically generated reports to the Share Point Portal.
• Defined report layouts for formatting the report design as per the need.
• Developed Sub Reports, Matrix Reports, Charts, and Drill Down Reports, using SQL Server Reporting Services.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• In depth knowledge in SSRS for report generation to create various types of reports.
• Administrated the created reports by assigning permission to the valid user for executing the reports.
• Created logins, users and configuring permissions and assigning roles to users.
• Worked on the creation of views to restrict access to data in a table for security.
• Involved in database schema design and development.
• Involved in Migration of databases from SQL Server 2005 to 2008 R2.
• Involved in design and implementation of SQL Server 2012 in development, test and production environments.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and functions.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Creating tables, indexes and designing constraints, wrote T-SQL statements for retrieval of data, and involved in performance tuning of T-SQL Queries and Stored Procedures.

Environment: SQL Server 2005/2008 R2/2012 Enterprise Edition, SSIS, SSRS, MS PowerPoint, MS Project, Oracle, PL/SQL, C#, VB.Net, XML, Visual Studio 2010 & 2008,MS Visio 2007,Team Foundation Server, JIRA

Confidential, Atlanta, GA

MS BI Developer

Responsibilities:

• Played role in design of scalable, reusable, and low maintenance SSIS templates.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms such as Lookup, Fuzzy grouping and Row Count Transformations and type 1 and type 2 slowly changing dimensions
• Created SSIS packages for application that would transfer data among servers and perform other data transformations.
• Scheduled SSIS packages by creating the jobs.
• Generated country wise, region wise reports using global variables, expressions and functions using SSRS.
• Created Scorecards and added them to dashboard using Dashboard Designer and deployed the dashboard to SharePoint.
• Defined report parameters and wrote queries and procedures for drill down and parameterized reports using SSRS.
• Created Report Snapshots to improve the performance of SSRS
• Generated parameterized reports to enable/disable the parameters based on user selection in SSRS
• Worked on performance tuning, writing stored procedures and creating indexes.
• Implemented complex stored procedures and automated them using SQL Server Agent
• Created triggers (Instead Of and after) for auditing purposes.
• Managed the security of the servers, creating the new logins and users, changing the roles of the users.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2005/2008 R2, T- SQL, MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), VB.NET, Microsoft SQL Server Analysis Services (SSAS), SQL Server Data Tools.

Confidential, Deerfield, IL

MS BI Developer

Responsibilities:

• Created ETL packages using heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.
• Used multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge, Union All, Lookup, Derived Column, Merge Join, Fuzzy Lookup etc., and containers like For Loop, For Each Loop and Sequence Container.
• Used Event Handlers for Custom Logging using complex stored procedures for various events (On warning, On Pre and Post-Execution, On Task Failed etc.)
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager.
• Implemented perspectives and KPI using calculated measures based on requirements.
• Identified and defined the datasets for Report generation.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using Reporting Services.
• Created alerts, notifications and emails for system errors, insufficient resource, fatal database errors and hardware errors. Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server and vice versa.
• Set up Profiler Traces, Analyze and replay Profiler Traces for Performance and long running queries.

Environment: MS SQL Server 2008/2005, T-SQL, SQL Server Integration Services (SSIS), SQL Server Data Tools, SQL Server Reporting Services (SSRS 2008), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel.

Confidential

SQL Server Developer

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Worked on replication server and managed fine tuning of database objects and server.
• Worked on DTS Packages, DTS Import/Export for Transferring data from Heterogeneous Database.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created Triggers to enforce data and referential integrity.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Used DTS to migrate the tables to the Data Warehouse. Handled different DSS (Decision Support Systems) for various applications.
• Manage customer expectations by clearly documenting and maintaining project deliverables, plans, and status throughout life of the project.
• Used Report Builder for Ad-hoc reporting.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Handled database objects with Enterprise Manager and Query Analyzer.
• Involved in developing logical and physical database using Erwin, Normalization, Dimension Modeling and Enterprise Manager.
• Debugging PL/SQL packages to troubleshoot issues.
• Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor and TOAD.
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and dead locks.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Java, C#, VB.Net, ASP.Net, Oracle, PL/SQL, Enterprise manager, MSOffice & Windows 2K platform.