PROFESSIONAL SUMMARY:

• Around 11 years of Professional experience in IT industry as a SQL Server /BI developer /Data Modeler /Report Analyst
• Confidential certified technology specialist (MCTS) and certified information technology professional (MCITP) in SQL server 2005
• Confidential certified technology specialist MCTS for business intelligence
• Experience in Fine Tuning SQL queries and T - SQL and PL\SQL queries & improving the performance of the Database.
• Information gathering, analyzing the information gathered, documenting the functional or business requirements
• Good SQL Server 2000/2005/2008/2012/2014 Administration skills including user authorizations, Database creation, backup, restore, replication, scheduling and clustering
• Experienced in pulling data from Upstream Sources into staging and eventually destinations using SSIS
• Converted reports from crystal and MS Access to SSRS
• Used C# for script task within SSIS, both to call Rest API and retrieve data through Flat Files, Outlook
• Expertise in Manual Testing, Mainframe Testing, Automation Testing and Database Testing
• Excellent understanding of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Test Methodologies from project definition to post deployment
• Good experience with writing and utilizing SQL queries for data verification in Oracle and other RDBMS
• Upgrading data to recent versions from earlier versions using MS Access, SQL server
• Experience in Database Development and Data modeling such as Creation of Tables, Stored Procedures, Triggers, Views and Functions using Transact-SQL
• Experienced in using Data Modeling tools like Visual Studio, ERWIN, MS-Visio
• Extensively used crystal reports, SSRS to generate reports based on the client needs
• Experienced in building up dashboards using MOSS 2007 and knowledge on performance point
• Extensively involved in data extraction and loading using DTS in MS SQL Server 2000 and SSIS in MS SQL Server 2005. Import Export data, Bulk Insert and BCP. .
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.
• Experienced in converting crystal reports to SQL reports
• Experience in Data Conversion and Data Migration from earlier versions to current SQL server using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Extensive exposure in SSIS, SSRS and SSAS and charting tools like graphical charting
• Good knowledge of share point 2007 in managing documents creating workspaces. Exposure towards moss 2007 and performance point.
• Knowledge on MES, TFS, MDX, Replication understanding C#, .net (validated applications using asp.net) concepts
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

TECHNICAL SKILLS:

Operating Systems: Windows 2003 / NT / XP/ME/9.X, UNIX (Solaris 8.0/9.0)

Languages: C, C++, JAVA, VB 6.0, T-SQL, Java/VB Script, C#

Web Technologies: HTML, WML, XML

Databases: MS SQL SERVER 2014\ 2 / 2000 / 7.0, MS Access 2003, ORACLE

Packages: G-Track, JIRA, MLH, MS Visio, MOSS 2007, ERWIN, CSS, VSS, TFS

Testing: Win Runner, Load Runner

ETL tools: DTS, SSIS, SSAS, SSRS, Informatica, ProClarity, Crystal Report 9/11

Database Tools: SQL Enterprise Manager, SQL Profiler, SQL Agent, SQL Alerts, SQL Mail, SQL Client Configuration utility, Backup Server, Replication server, OLAP Services, Replication Tools

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

SQL Server \ Data Warehouse \Application Developer

• Involved in re-writing SQL Scripts and SSIS Packages to enhance performance within EDW environment
• Worked on C# Scripts with SSIS to call Rest API to retrieve and push data to Eloqua
• Worked with the marketing team to gather requirements as per their needs for several campaigns
• Unit tested and code reviewed Proc’s following SDLC life cycle
• Used different database objects to fix the existing issues
• Handled and addressed various ad-hoc and Data Extract Workfront Tickets on a priority basis
• Worked on T-SQL scripts to make changes and load data into Data Warehouse
• Worked on C# to break up data from Various Sources to load tables as per the requirements

Environment: SQL Server 2016/2014, C#, MS Visio, TFS, SSIS, SSRS, Eloqua. MS Dynamics, Workfront

Confidential, Bellevue, WA

SQL Server \ SSIS Developer

• Good understanding of Partner Incentives Program and its relationship to business requirements
• Extracted data from Upstream Sources to stage, cleanse and transformed data into SQL server using SSIS
• Worked and Developed new SSIS Packages introducing new programs to the existing Program to enhance the Partners Flexibility
• Developed Packages and Increased performance by tuning the Procedures and ETL Design
• Written Complex Stored Procedures, Views and Functions on the SQL Server 2012 as part of the ETL to move data between Databases across Servers
• Gained good knowledge and used TFS as a source control, build to deploy to various environments
• Created Stored procedure to pull data for reports
• Used SSRS to build reports both for external and internal users maintain security
• Worked on C# to call API and breaking up data from Various Sources to load tables as per the requirements

Environment: SQL Server 2012/2014, C#, MS Visio, TFS, SSIS, SSRS, EXCEL 2007

Confidential, Worcester, MA

Soarian Reports Programmer \ ETL Developer

Responsibilities:

• Good understanding of Soarian reporting architecture and its relationship to business requirements
• Worked on Soarian Admin Desktop in Clinical, Soarian Financials and Soarian Analytics
• Worked Siemens pharmacy data into Soarian Clinicals and DSS
• Automated SSIS to load the mappings, used it for loading Different trustee data loads
• Extensively used SSIS as part of ETL between Data Bases and used different type of Configurations on a case by case scenario
• Migrated oracle data to SQL Server as part of migrating data to Data ware house Using SSIS
• Worked on Package Configuration to in corporate smoke test within SSIS Packages
• Developed Crystal Reports and Increased performance by tuning the Procedures
• Written Complex Stored Procedures, Views and Functions on the SQL Server 2008 to create the reports in Soarian Clinicals, Soarian Financials, and Soarian Analytics.
• Developed Procedures for Data Extract and send them to different Sources through Soarian Scheduler, SSIS Packages

Experian, Denver, CO

SQL Server Database Engineer \ ETL Developer

Responsibilities:

• Involved in re-writing reports from OLTP environment
• Increased the performance of existing Stored Procedures by writing Sargable code
• Unit tested and code reviewed Proc’s following SDLC life cycle
• Used different database objects to fix the existing issues
• Handled and addressed various ad-hoc and Data Extract Tickets on a priority basis
• Worked on T-SQL scripts to make changes and load data into Data Warehouse
• Worked on C# to break up data from Various Sources to load tables as per the requirements

Environment: SQL Server 2012, MS Visio, Sarema Dimensions Team track, SSIS, XML, VB Script. C#

Confidential, Irvine, CA

SQL Server / SSIS Developer / Report Analyst

Responsibilities:

• Involved in re-writing reports from OLTP environment to Data Warehousing environment
• Designed and engineered the flat file data formatted and automated the process to pull data and post it to Share Location
• Used VB Script to format excel files for various trustees
• Involved in Database Administration roles like monitoring, production support and assigning roles
• Designed packages using SSIS to load legacy data and to call web service tasks
• Worked with XML Files to load/ pull data to/ from database
• Gained experience on JIRA ticketing system and updated the progress on various projects
• Worked on C# to call API
• Hands-on experience using PL/SQL while converting procedures from SQL Server to Oracle
• Worked on MLH to deploy reports(SSRS) to various environments
• Wrote ETL scripts to load data into dimension and fact tables and scheduled them to refresh on a hourly basis
• Designed and re-written SSRS reports from stage to EDW environment
• Experienced in Creating linked, sub reports to enhance the drop down and drill through capability
• Wrote data driven and time valued subscriptions as per the report and business requirement
• Made use of the Tablix report object to created reports and to avoid unnecessary grouping

Environment: SQL Server 2008, SSRS, SSIS, DTS, MS-Visio, VSS, JIRA, VB Script, T-SQL, PL/SQL, C#

Confidential, West Chester, PA

SQL Developer / BI Developer / ETL Developer

Responsibilities:

• Created new Tables, Stored Procedures and Functions as per the technical document
• To establish a single process and application that supports the process for complaint capture, product analysis, and vigilance reporting, and trending at a franchise level
• Worked with business users to define and analyze problems, create logical data model, implement physical data model, and the implications of business solutions to the current and future environment
• Worked with MS Access, Cognos to create and modify the existing reports
• Identified new process, finding out gaps in existing process, arranging training modules for new process development and implemented
• Implemented Normalized database from scratch, Using Stored Procedures and SSIS Packages
• Troubleshoot ETL scripts written in PL/SQL in case of issues raised
• Designed and automated different types of reports using SSRS
• Used lock hints like nolock, Xlock for better performance and efficiency
• Create joins and sub-queries for queries involving multiple tables
• Data migration using ETL scripts, in order to create a complete new environment to avoid the discrepancies while doing reporting

Environment: SQL Server, SSRS, SSIS, DTS, MS-Visio, MS Access, Erwin, G-track, PL/SQL

Confidential, Columbus, OHIO

SQL developer/SSRS developer

Responsibilities:

• Automation of reports using SSRS through stored procedures and parameters
• Designed reports from scratch involving drilled-down and drilled through reports and sub-reports
• Generated Report model so that the users can develop their own projects using report wizard
• Developed stored procedures with complex calculations and nested joins from different tables within a single and more databases with the help of linked server
• Integrated report manager with SharePoint in Naïve mode, eliminating the first layer of security to the report manager
• Used ProClarity as the reporting and analyzing tool as a Dashboard for the cube structures
• Assisted fellow developers with OLAP and Doing ETL in transformation of cubes
• Assisted in migrating cubes from 2000 to SQL server 2005 using SSIS
• Used SSIS packages to load date from spreadsheet into the data base and also used packages to move data between databases (oracle, flat-files) on different servers
• Migrated reports from crystal and MS Access to SSRS and scheduled them appropriately

Environment: MS SQL Server 2005, Erwin, SSIS, SSRS, SSAS, ProClarity, Visual Studio, MOSS 2007

Confidential, Cincinnati, OH

MS SQL Developer, Freight Re-allocation

Responsibilities:

• Created new Tables, Stored Procedures and Functions as per the technical document
• To establish a single process and application that supports the process for complaint capture, product analysis, and vigilance reporting, and trending at a franchise level
• Worked with business users to define and analyze problems, create logical data model, implement physical data model, and the implications of business solutions to the current and future environment
• Identified new process, finding out gaps in existing process, arranging training modules for new process development and implemented
• Troubleshoot ETL scripts written in PL/SQL in case of issues raised
• Designed and automated different types of reports using SSRS
• Used lock hints like nolock, Xlock for better performance and efficiency
• Create joins and sub-queries for queries involving multiple tables
• Data migration using ETL scripts, in order to create a complete new environment to avoid the discrepancies while doing reporting

Environment: MS SQL Server 2005, T-SQL, ETL/SSIS, SSRS, INFORMATICA, Erwin 4.1, Oracle

Confidential

MS SQL Server DBA/Developer, Trainee

Responsibilities:

• Created new Tables, Stored Procedures and Functions as per the technical document
• To establish a single process and application that supports the process for complaint capture, product analysis, and vigilance reporting, and trending at a franchise level
• Worked with business users to define and analyze problems, create logical data model, implement physical data model, and the implications of business solutions to the current and future environment
• Identified new process, finding out gaps in existing process, arranging training modules for new process development and implemented
• Implemented Normalized database from scratch, Using Stored Procedures and SSIS Packages
• Troubleshoot ETL scripts written in PL/SQL in case of issues raised
• Designed and automated different types of reports using SSRS
• Used lock hints like nolock, Xlock for better performance and efficiency
• Create joins and sub-queries for queries involving multiple tables
• Data migration using ETL scripts, to create a complete new environment to avoid the discrepancies while doing reporting

Environment: SQL Server 2000/7.0, T-SQL, Windows 2003 Server, VB.net