OBJECTIVE

• To be part of an organization which progresses dynamically renders creative and challenging environment, where I can put my expertise to best use.

SUMMARY

• A Microsoft Certified professional with 8+ years of total IT experience in the Design, Modelling, Development, Implementation and Support of SQL Server 2008\2012\2014, Oracle 9i\10g, ETL.
• Expert in analysing, designing, development, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2008/2014, SQL Server Integration Services, DataStage(8.0/7.5) and good knowledge on SQL Server Analysis Services(SSAS)
• Masters in Electrical and Computer Engineering with 10 GPA from University of Windsor.
• Microsoft certified for Querying Microsoft SQL Server 2012.
• Expertise in writingT - SQL Queries, Dynamic-queries, sub-queries and complex joins for generatingComplex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Extensive experience on all types of Microstrategy Filters, Prompts, Templates, Metrics, Consolidation and Custom Groups.
• Experience in Data Extraction, Transforming and loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, Data Transformation Services (DTS), DataStage, Bulk Insert, BCP).
• Experiences working with package configurations in SSIS2008\2012, Migration of data, file processing and C#.NET coding in the script task of SSIS.
• Able to balance and prioritize multiple tasks and responsibilities. Very good at working as a team member, self-management projects and also managing the team.
• Strong interpersonal and communication skills with an ability to lead a team and keep them motivated.
• Reliable, energetic, self-starter, and flexible worker, with ability to communicate effectively with all types of personalities.
• Experience in Dimensional Data ModelingStarandSnow Flake Schemas.
• Established experience in all phases of the Software Development Life Cycle (SDLC), including agile and scrum

TECHNICAL SKILLS

RDBMS/ETL: SQL server 2008/2014, Oracle 9i/10g, SSIS2008\2014, Informatica Powercenter 8.1IBM Information Server. DataStage V7.5\8, MySQL, DB2.

Programming Languages: SQL, PL/SQL, C, C++, HTML, PHP and C#.NET.

Reporting Tools: Business Objects (Crystal Reports 8.5/9), SSRS 2008/2014 and Cognos 7/8MicroStrategy 9.2/ 10.0.

Operating Systems: Windows 2000/XP, MS-Windows NT/2000/98/95, MS-DOS, UNIX, Linux.

Packages: Ms- Access, Ms-Word, Ms-Excel, Ms- PowerPoint.

Development Tools: TOAD, SQL*Navigator, SQL*Loader, Eclipse3.0.

PROFESSIONAL EXPERIENCE

Confidential

ETL/Database Developer (SQL 2014, SSIS 2008\2014, SSRS)

Responsibilities:

• Worked on PossibleNow project to maintain a centralized location for customer preferences, for easy management, retrieval and auditing.
• Created SSIS packages to load the files received on daily basis from PossibleNow in to DW and update the DW depending on the data received by implementing SCD type 2.
• Designed SSIS packages to create files for PossibleNow of all the preference changes for the previous day and send this to client on daily bases.
• Modified the existing SSIS packages to send the files to client SFTP which was using password authentication to use private key authentication.
• Created stored procedures, tables and functions to process the files and also to create the output files.
• Experienced in writing complexStored Procedures,Triggers,Tables,Viewsand SQL Joins and adhoc queries using T-SQL.
• Experienced in modifying existing stored procedures and performance tuning of the T-SQL queries.
• Worked with different types of transformations like SCD, Lookup, Derived column, etc.
• Modified the existing stored procedures to update the data in DW based on the files received.
• Worked on multiple reports using SSRS like, daily subscription reports and monthly subscription reports.
• Created multiple sub-reports, parametrized reports and charts for the internal business.
• Migrated existing Crystal reports to SSRS and also added new functionality to the report.
• Managed a team of two in assigning the tasks, making sure the projects are delivered on time and peer code review.
• Used Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created technical design document, deployment instruction document and also deployment package.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS) and other Data Warehouse concepts.
• Worked with GIT repository in pushing and pulling the code.

Confidential

ETL/Database Developer (SQL 2008\2014, SSIS 2008\2014, SSAS, SSRS)

Responsibilities:

• Worked in Risk Information Strategy for the Enterprise project to develop an enterprise-wide ability to manage risk within Confidential ’s Risk Appetite through more effective and efficient use of data and technology.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAScubes.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Created mapping sheet to link the data from the source system to destination system, transformation, reject rules based on the requirement.
• Extensively worked withSSIStool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split,Lookup, Aggregator,Multicast and Derived Column.
• Expertize in writing complex Adhoc T-SQL queries using with CTE functionalities, creating Stored procedures, Function and Triggers.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize T-SQL queries for improved performance and availability.
• Responsible for efficient design and usage of various attribute dimensions like Customer, Product, Payment, Geographic and Time dimensions, and integrating them into reports displaying forecasting metrics.
• Responsible for designing and executing Application objects and Schema objects using MicroStrategy Desktop.

Confidential

ETL/Database Developer

Responsibilities:

• Worked with Client Information Warehouse (CIW/Backbone) for capturing historical client revenue and credit exposure and for calculating returns based on assumptions regarding costs and risk capital
• Involved in Capturing monthly metrics for ICG and CCB clients for Reference Data, Deposits, Exposure, Capital, &Returns
• Support Banking, TTS, Markets, and CCB coverage finance teams with the data loads.
• Created SSIS package to import credit and debit ratings of daily and full feeds from S&P client into CIW backbone warehouse.
• Created documents for SSISpackage to deploy into production environment and used package configuration to export various package properties to make package environment independent and scheduledJobsusingSQL Server Agent.
• Created Microstrategy Schema objects and Application objects using Microstrategy Desktop and Architect
• Responsible in creating complex packages to unzip (.gz/.Zip) files, process them and validate the row counts, logging information and send email.
• Created logical data models, recognize source tables and columns, to build Microstrategy Schema objects including Attributes, Facts, Hierarchies and Relationships necessary to create MicroStrategy project.
• Well versed in performance tuning of T-SQL queries and stored procedures.
• Created new database objects like Tables, User Defined Functions, Triggers, Procedures, Functions, Indexes and Views, T-SQL joins and complex queries as per the project requirements.
• Developed dashboard reports usingReporting Services, Report Model and ad-hoc reporting usingReport Builder.
• Experience in creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture (Table,chartandmatrix report).
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Experience in production support, used to support monthly runs overnight and fix any issues during the process.
• Generated several drill down and drill through reports usingSSRS.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema

Confidential

Database Developer

Responsibilities:

• Responsible for design and developing complex SSIS 2008\2012 packages for processing the client’s transactional files.
• Design and implement an ETL infrastructure that is robust, flexible, scalable, and secure that supports the Strategic Initiatives of the Enterprise and to implement reusable services with Error Handling functionality.
• Created complexStored Procedures,Triggers,Tables,Viewsand SQL Joins and adhoc queries using T-SQL for the reconciliation process.
• Expertise in using recursive CTEs, CTE, temp tables in T-SQL and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Responsible for creating daily/weekly/monthly reconciliation reports using SSIS and move the files between SFTP locations with Error handling functionality.
• Wrote complex queries to pull the data and create clients (Apple) transactional reports of settlement and refunds which helps the client to match their daily transactions.
• UsedMicrosoft Visual C#in script component of SSIS to a read XML file and write them into multiple XML files based on the merchant ID, encrypt the files and copy them into the client SFTP location.
• Remarkable experience in trouble-shooting and providing in-depth analysis to resolve production issues.
• Validation of data accuracy and worked on the Reconciliation process for major clients like Apple, Alibaba, LinkedIn, etc.
• Download files from merchant’s SFTP location, process the files, mask any personal information and upload the masked file to merchant’s SFTP.
• Created automated processes for the activities such as pick up files from clients source SFTP, mask any sensitive information in the file with the standard format, encrypt the file with public key and place the encrypted file into the destination SFTP.
• Responsible for the peer code review and unit testing of database development and SSIS packages.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Lead a team of 4, responsible to distribute the work among the team members.
• Ensure deliverables are prepared to satisfy the project requirements and schedule.
• Coordinate with internal and external customers as necessary.

Confidential

Conversion Analyst

Responsibilities:

• Analyzing the data in DB2 getting the Database ready for migration.
• Used SSIS packages to extract the data into the staging area.
• Created complex dimension tables, fact tables.
• Created Script Tasks and Bulk Insert tasks in SSIS during the control phase.
• Debugging the package during extraction Phase (Mostly due to the size of the data)
• Created Tables and views for Staging DB and embedded with SSIS 2008 packages after the extraction to automate and standardize the process.
• Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to SQL Server 2008.
• Involved in Design and development of Data Marts for specific Business aspects which include Confidential ts, Claims, and Providers.
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Used DataStage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding.
• Developing the Dashboard reports using Cognos Report Studio.
• Conducted daily and monthly meeting with the team to discuss about the progress of the projects and to make sure all deadlines are met.
• Conducted training for all the team members for the tools used in the company.
• Created detail, Summary, Cross tab, Parameter driven reports using SQL Server Reporting Services.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved in T-SQL Query Optimization to increase the performance of the Report.
• Developed Reports for business end users using Report Builder with updating Statistics.
• Created reports for Confidential t Information, Clinical Information, Diagnosis Information, and Providers Information.
• Hands on experience with standard T-SQL queries, stored procedures, functions and triggers.

Confidential

Database Analyst (SQL 2005, SSIS, Crystal Reports IX, Oracle).

Responsibilities:

• Used PL/SQL to create Procedures, Functions, and Triggers.
• Involved in Unit Testing and writing Queries with T-SQL.
• Involved in requirement gathering, design and development of data bases.
• Data migration from older version to newer database version using ETL tool.
• Developed procedures and functions using SQL Server 2000 for customization.
• Responsible for designingreports, tables, queries, store procedures, views in SQL Server.
• Created detail, Summary, Cross tab, Parameter driven reports using Crystal reports 9 against SQL Server and Oracle.
• Gathering requirements from business users, documentation, training to end users.