SUMMARY

• 7+ years of robust professional work experience in Data Design and Development on Microsoft SQL Server 2012/2008R2/2014/2016, Performance Tuning, SSIS/DTS Package Configuration, SSRS and Data - warehousing, Data Cleaning, Data Aggregation, Data Mining, Data Analysis, Data Manipulations, Risk Management and Reporting withSQLincluding design, development and implementation of transactional and analytical databases for Financial/Bank and Health Care industries.
• Experience include supporting the department in performing key business processes expert knowledge usingSQL on Windows and Mainframes platforms.
• Experience working inSASGridenvironments (High Performance Analytics Suite) andSASUnix for automation.
• Strong skills onData Manipulation Language (DML) and Data Description Language (DDL).
• Worked extensively onDatamodeling concepts and their implementation in Dimensional modeling using ETL Processes forDatawarehouses.
• Experience inDataWarehouse Development, Enhancement, Migration, Maintenance and Production support projects.
• Working withDataStageManager, Designer and Business and Product Owners.
• Experienced in integration of variousdatasources (DB2-UDB, SQL Server, PL/SQL Oracle and MS-Access) intodatastaging area.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing usingSQLServer Integration Service (SSIS).
• Extensively worked on Relational Databases Systems like Oracle 11g/10g/9i/8i, MS SQL Server, Teradata and Source files like flat files, XML files and COBOL files.
• Expert in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS).
• Extensive experience in designing, developing and delivering business intelligence solutions using SQL Server Integration Services (SSIS) and Reporting Services (SSRS).
• Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
• Created a new SSIS package and added a Dataflow and a Script Component configured to Source.
• Involved in every phase of Software Development Life Cycle (SDLC) processing the areas of Analysis, Design, Development, Implementation and Testing of Software Applications.
• Experience in building data warehouses/data marts by extracting and transforming data from Oracle/Teradata systems using Teradata Utilities.
• Extensive experience in usingSASEnterprise Guide in developing stored processes and performing statistical analysis.
• Extensive experience in report generation usingSQLServer Reporting Services (SSRS) from relational databases.
• Expertise in extracting and loading data to and from various RDBMS including ORACLE, MS SQL SERVER, TERADATA, FLAT FILES, XML FILES and IBM DB2.
• Handled more than 10,000 transactions, withfraud protection for consumers and guaranteed payment for merchants.
• Extensive Experience in verifying defects, bug tracking and modifying datasets for the improvement of existing system.
• Documented methodology, data reports, and model results.
• Self-motivated and Organized Team player with excellent analytical and communication skills.

TECHNICAL SKILLS

Programming: SQL, PL/SQL, MSSQL, SAS, R

Databases /Servers: MS SqlServer 2008/2005/2012/2014 and 2016, MS Access, DB2.

Package: MS Word, MS Excel, MS Power point, MS Visio.

Languages: SQL, PL/SQL, UNIX Shell Scripting, Perl, JAVA, C, VB, .net.

Environment: Windows 8,10 pro, IBM Mainframes

Desktop: Excel, Word, Visio, Outlook, SharePoint, Info path.

Testing Tools: HP Quality Cente.

BI Tools: Tableau, Cognos.

Methodologies: Six Sigma, DMAIC.

Automation: KSH scripting, Control M.

Additional Technologies: SAS/BASE, SAS/SQL, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/ACCESSSAS Enterprise Guide, SAS Data Integration (DI) Studio, SAS Enterprise Intelligence Platform 9.1

PROFESSIONAL EXPERIENCE

Sr SQL DATABASE DEVELOPER

Confidential - OH

Responsibilities:

• Involved in migrating data from different DB’s to CMS. Then moving the data into clients DB after performing proper validations.
• Migrated Packages from DTS to SSIS. ETL, data quality and clean ups for SSIS packages.
• Designing logical and physical data model with Aqua data studio tools.
• Creating and managing schema objects such as tables, views and stored procedures.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat files, Excel files and OLEDB to SQL Server.
• Migrated SSIS packages from SQL Server 2005 to SQL Server 2008.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Worked with business analysts and others to develop project specifications. As a Developer I have implemented SSIS Business Intelligence Life Cycle such as SSIS packages Configurations (SQL Server), Deployment, Tet, Production environments.
• Performed documentation for all the projects I worked on. Involved in fine tuning and performance and query optimization of the Database as required by the application.
• Used DDL and DML for writing stored procedures to check the data entry ad payment verification.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Interacted with the users for understanding and gathering business requirements.
• Involved in analysis, design, development, testing, deployment and user training of Analytical and transactional reporting system. Involved in query optimization for faster processing of queries.
• Created allocation and other reports using SQL Server Reporting Services (SSRS).
• Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Loaded flat files into SQL Server tables and vice versa usingSSIS.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, and Expression.
• Created XML configuration files to dynamically alter package properties.
• Developed error handling routines for packages using both script tasks as well as in the error handling tab. Developed Unit Test Plans forSSISpackages.
• Responsible for allocating responsibilities and coordinating ETL efforts among team members to ensure best practices are used.
• Provided support for all operations focusing on integration of new products and services.
• Worked with business stakeholders, application developers and production teams and across functional units to identify business needs and discuss solution options
• Performed quality assurance and testing of SQL server environment.
• ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Created/managed configuration files in order to deploy SSIS packages in different environments.
• Support current production jobs by troubleshooting long running queries and optimize them to improve performance using different optimization techniques, DTA/ITW and Execution Plan.
• Wrote function code for different tasks in the database table.
• Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
• Involved in planning, designing and implementing application database code objects, such as stored procedures and views.

Environment: SQL Server 2005/2008/2012/2014 , SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), XML, SQL Profiler, Cognos, Visual Studio 2015/2017, Excel 2016, MS Word. Oracle 10g, .NET, c#, Visio 2003, S Share Point, MS Excel, UNIX, DB2.

SQL/SSIS/ETL DEVELOPER

Confidential, SCHAUMBURG, IL

Responsibilities:

• Responsible for the design, development and administration of transactional and analytical data constructs/structures. Includes within those responsibilities are the areas of data access and delivery technologies. Includes expertise in data quality, data organization, metadata, and data profiling.
• Demonstrated ability to identify issues as they arise and find out root causes.
• Demonstrated ability to move data between production systems and across multiple platforms.
• Demonstrated ability to improve existing data processes through optimization, automation, innovation, etc.
• Demonstrated ability to learn new technologies. Coordinating others work while involved with multiple work streams.
• Configured SQL Server maintenance plans to automatically back up SQL Server Databases, optimize index and update statistics.
• As a primary SQL developer in creating complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Designed and implemented Modular and Reusable ETL processes and associated data structures for Data Staging, Change Data Capture (CDC), Data Balancing & Reconciliation, Exception Handling & Reject Recycling, Surrogate Key Generation & Assignment, Data Lineage Tracking, ETL Auditing, etc.
• Used SQL Server Profiler and Extended Events to trace long running queries for optimizing databases.
• Performed code reviews, analyzed execution plans, and re-factor inefficient code Follows data standards, resolved data issues, completed unit testing and completed system documentation for ETL processes.
• Got good experience with supporting applications on backend.
• Data architecture, design and creation of MS SQL tables, views, triggers and other objects required for web statistics & analysis.
• Created SSIS Packages to Extract, Transform and Load (ETL) the data into Reporting instance to generate the reports easily and quickly.
• Generated T-SQL scripts for Data retrieval, Manipulation & Validation for various applications.
• Involved in Performance Optimization of Queries & Stored Procedures by analyzing Query Plans, blocking queries, Identifying missing indexes etc.
• Gathering user requirements for application to meet end Client specifications.
• Analyze the Business Requirements, Functional Specification, Use Cases and Configuration Spec Documents.
• Extensively worked on feeds as required to deliver data from upstream systems to the Quick (Risk calculation) and Raptor (market Risk reporting) databases.
• Design Test Plan, Test Strategies, Test Scripting and Traceability Matrix.
• Writing & debugging the SQL scripts. Prepare Automation Scripts using QA Automation Tool.
• Mentor less Experienced Team Members on needy basis on Best practices.
• Maintaining test script relationship and assigning Requirement id for ease of traceability.
• Make recommendations related to maximizing investment in existing test automation tools, identify report, escalate, monitor, and mitigate project and product risk.
• Data extraction, transformation and load (ETL) processes will use DataStage environments.
• Created and troubleshot stored procedures and queries performances using SQL Server Profiler, Performance Monitor and DBCC Commands.
• Developed ad hoc and customized reports using SQL Server Reporting Services (SSRS).
• Converted DTS packages to SSIS packages, validating the packages, and migrating to SQL Server 2005 Integration services.
• Used SQL to download data and SASPROC SQL pass through facility to connect to Oracle tables.
• Involved in building and maintaining SQL scripts, indexes and complex queries for data analysis and extraction.

Environment: MS SQL Server, MS Word/ Excel, SSIS, SSRS, visual studio, windows XP/8/10.Datastage server, T-SQL, Oracle 10g, MS Excel, Windows Server 2003, JavaScript, XML, ETL, Crystal Report, SQL task, QA Automation.

SQL DEVELOPER

Confidential

Responsibilities:

• Responsible for creating Databases, Tables, views, stored procedures, Triggers and Rules.
• Creating and maintaining UI prototypes and specifications. Involved in installation and configuration of SQL server 2005 on servers.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using TSQL in SQL Server 2005.
• Involved in writing T-SQL programming for implement stored procedures and functions for different tasks.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Implemented Error Handling using Try-Catch block.
• Collaborated with the applicationdevelopersin data modeling and E-R design of the systems.
• Also created, modified, maintained and optimized SQL server database.
• Maintained the documents and create reports for the business analysts and end-users.
• Responsible for the management of the database performance, backup, replication, capacity and security.
• Responsible for creating and deploying the reports.
• Collaborating with Product Managers and Software Engineers to provide guidelines on solid UI design.
• Keeping up to date with the latest industry trends in UI design and usability.
• Translating market and product requirements into UI designs in the form of Conceptual models, Wireframes and prototypes.
• Creating new datasets from raw data files using Import Techniques and modified existing datasets using Set, Merge, Sort, Update, and conditional statements.
• Designed the user interfaces using Web Server Controls which are built on ASP.NET Server Controls.
• Developed Business Logic Component using Web Services, WSDL.
• Used .NET Framework 3.0 throughout the project and converted existing code from 1.1 to 3.0.
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes.
• Created SSIS packages to transfer data from Oracle to SQL using different SSIS components and used configuration files and variables for production deployment.
• Developed SSIS packages to consolidate date from various data sources and also data loads from various types of source files like EXCEL, ACCESS, Flat files and CSVs and converted XL to SQL reporting.
• Used various transformations in SSIS dataflow, control Flow using for loop constraints and Fuzzy lookups created for several staging databases.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and family transfer into data marts and performed action in XML.
• Wrote complex quires, triggers, stored procedures, views and user defined functions.
• Design and implement database logical and physical schemas.
• Responsible for database logical and physical schemas.
• Maintenance of development, system test, assembles test and integration servers and databases.

Environment: - .NET Framework 2, Visual Studio 2003/2005/2008 , Web services, XML, HTML, SQL Server 2000/2005/2008 , SQL Server Integration Services (SSIS), Visual Studio 2005.

DATA ANALYST

Confidential

Responsibilities:

• Modified data usingSQL DML statements.
• Employed techniques like sorting and merging on the raw data sets and coded them using SQL to get the required output.
• Prepared graphs using the modified data for business analysis.
• Creation of Data Sets on the Remote Server.
• Primarily worked on a project to develop ETL Products to handle complex and large volume healthcare claims data. Designed ETL framework and developed number of packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local MS SQL 2012 databases to facilitate reporting operations.
• Worked as a developer in creating complex stored Procedures,SSISpackages, triggers, Cursors, tables, and views and otherSQLjoins and statements for applications.
• UsedSSISpackages to load the data from spreadsheet into the database and also used packages to move data between databases (flat files) on different servers.
• Extracted data from various data sources CRM, ERP, and Legacy.
• UsedSSISto transform data intoSQLdatabase via FTP from Text files, MS Excel as source.
• Used SMA Job scheduler to schedule jobs as advised by the business user.
• Worked as a developer in creating complex Stored Procedures,SSISpackages, triggers, cursors, tables, and views and otherSQLjoins and statements for the applications.
• Created format files to support BCP transformation inSSISvia FTP.
• Worked onSSRSto handle Ad-hoc requests.
• Designed tables, constraints, necessary stored procedures, functions, triggers and packages using T-SQL.
• Worked on DTS packages onSQLserver side.
• Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions.
• Worked to get the data dynamically into the UI from SQL Database.

Environment: MS SQL 2012, Windows XP/8, MS Word, Excel, SSIS, visual studio.