PROFESSIONAL SUMMARY:

• Highly motivated SQL server developer with 9+ 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: Microsoft SQL Server Management studio, Enterprise Manager, SQL Profiler, SQL Server Business Intelligent studio (BIDS), Source Tree, JIRA

Business Intelligence Platform: SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services.

Database Management Software: MS SQL Server 2017/2012/2014

T: SQL, PL/SQL, .NET, C#

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

Agile Methodology: Scrum, Kanban, JIRA Version Control

Source/Version Control Software: Bitbucket, Source Tree, TFS

Application Packages: MS Office Suite, MS Outlook.

Data Modeling Tools: MS Visio, Erwin

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Senior SQL BI/ETL Developer

Responsibilities:

• Responsible for creating packages based on given business requirements using SSIS 2013,2015.
• Designed dynamic SSIS packages to transfer, validate and archive data.
• Created multiple Stored procedures, views and ad-hoc reports to generate usage reports.
• Designed, modified and troubleshooted SSIS packages.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Developed custom processes to eliminate the need to keep junk records in QNXT production, for the purposes of data integrity and audit.
• Control Flows, which include tasks and containers that execute when the package runs. Organized tasks in sequences and in loops during creation of package in SSIS.
• Created different tasks in SSIS to cleanse, convert, move, modify the data from Import, Staging to final tables.
• Experience working on defects and gap analysis between the source systems and downstream business processes.
• Querying and analyzing to find out what is the relation between tables and prepare design documents and understand data mapping.
• Experienced working with 837I/P files along with all the different kinds of files received from clients.
• Used different Tasks (Data Flow, Execute SQL, Script, FTP, send mail etc.) and Transformations (Data conversion, Merge, Row count, multicast, Sort, Lookup, Conditional Split) in developing the SSIS Packages.
• Developed the technical design documents for projects based on the given business requirements.
• Hands on experience in creating facts and dimensions, involved in Dimensional Modeling.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan).
• Generated custom Preproduction Reports, Fallout Reports and record counts for different SSIS requirements and packages.
• Worked on Source Tree for version control and source code management.
• Assist with mentoring/guiding junior analysts and handled complex ad-hoc reporting

Environment: MS SQL Server 2014, T-SQL, Visual Studio Team Foundation Server, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Server BIDS, SSIS, SSRS, MS- Visual Studio 2013.

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, XML, Visual Studio 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 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 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

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.