SUMMARY:

• Over 13 years of in - depth hands-on experience in full software development lifecycle. Extensive working knowledge as a database designer, Report and ETL developer. Solid T-SQL coding and developer skills on outstanding communications and project management experience.Senior BI/DW consultant with 8 years of experience in MS SQL Server 2012/2008 R 2/2008/2005/2000 with Business Intelligence in MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS)
• Excellent working experience in various industries/domains such as Financial Services, Manufacturing, Telecommunication and Construction, Retail and IT Consulting industries
• Experience in interacting Business users to perform Business Process Analysis, Re-engineering, Business Requirement gathering (BRD), System Requirement Specs (SRS) documentation, system analysis
• Excellent ability in writing specifications and gathering requirements from the user to develop Reports as per the needs of the client and maintain documentation of the reports for future reference
• Involve in the full System Development Life Cycle (SDLC) of a Data Warehouse and responsible for designing, coding, testing, implementing and supporting the ETL processes for data warehouse solutions
• Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server, Access, Oracle and MYSQL Databases
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency
• Experience in Logical and Physical Database design and development, Data Conversion, Normalization and Data modelling using Erwin and SQL Server Enterprise manager
• Create T-SQL scripts to load the data to and from production servers and to the development servers
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS
• Experience in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services (SSIS)
• Expert in SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area, then used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, and finally transfer into data warehouse
• Excellent Hands on experience in SAS to SQL migration and SAS PROC SQL commands
• Experience in Importing/Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility
• Involve in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands using T-SQL
• Experience in normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modelling and reporting tools, worked with high volume databases with partitioned data
• Expertise in Developing and Extending MS SQL Server Analysis Services (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects
• Adept in defining referenced relationships and calculated members in SSAS and used MDX queries
• Expert knowledge and experience authoring, managing and deploying reporting solutions using SSRS
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS)
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger
• Worked on administration tasks such as Data loading, Batch Jobs, Data unloading, Backup & Recovery, User and Application Table Management, upgrades, creating Databases/File groups/Files/Transaction logs
• Hands on experience on gathering requirements, developing solution, managing application development, and data conversion and initialization across multiple environments such as Master Data Management ( Confidential )
• Expert in all the different stages in SDLC, RUP and in Project Management
• Demonstrate experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure

TECHNICAL SKILLS:

Windows, UNIX, TSQL, PL/SQL, XML, MDX, Toad, MS SQL Server 2012/2008/2005/2000 , DB2, Oracle 10g/9i/8i, SAS 9.4/9.3, Sybase, InforMaker, MS Access, Mercury Quality Center 8.2, SSIS, SSRS, SSAS, DTS, SAS, Informatica 8.2, Micro strategy 8, SQL Query Analyzer, DQ Analyzer, Microsoft Share Point 2007 / 2010, Omniture 13.5/14, Discover 2.8/3.0, Site Catalyst, SAS - 9.1/9.2, My Eclipse 3.1, MS Visio 2003, SmartLink, ICM, Microsoft Office Suite 2002/2003/2007/2010 , MS Project, MS Visio, JIRA, Service Now

PROFESSIONAL EXPERIENCE:

Confidential, Buffalo, New York

Sr. Development Manager / Team Lead / Data Analyst

Responsibilities:

• Analyzed different sources (BTS, RBC, SBA etc.) and created source to target mapping documents Developed ETL process flow to show how ETL transformations happening in LAND, CDC and stage layer
• Created several functional, technical specs and developed test cases / scripts of different projects
• Responsible to track the defects and change requests (CR) for different releases
• Developed monthly release related SQL codes using Oracle SQL developer against defects & CR
• Developed several test cases, test plans to perform Unit, System functionality testing for different releases
• Responsible to consolidate entire test scripts and upload in share point
• Validated address, contact privacy related files using Informatica Data Profiler in Informatica Analyst
• Responsible to develop business glossary of EPH technical field and established relationships Informatica Analyst
• Validated real time services (Insert, Update and Select) using Soup UI and Oracle SQL Developer
• Developed several ad-hoc reports using ‘ Confidential HUB’ and ‘ECH Publish’ databases using Oracle SQL Developer
• Responsible to perform analysis of the annual ‘Contract privacy’ files for several states using Informatica Analyst
• Responsible to create and maintain entire defect list using HPQC & HP ALM

Environment: Oracle 11g. Oracle SQL Developer, Informatica Master Data Management (IDD), Informatica Analyst, HPQC, HP ALM, Soap UI, Share Point 2010, MS Office Suite 2010

Confidential, Buffalo, New York

Sr. Database / BI Developer

Responsibilities:

• Analyzed several SAS models, process flows and created business process documentation and technical specifications documents
• Responsible to create several SAS data process flows and ETL processes using MS Visio
• Developed ETL frame work based on the existing SAS models by using SSIS and SQL Server
• Created SSIS Packages and complex transformations to extract, transform and load data based on the requirements
• Responsible to extract data from different databases (SQL Server), flat files, SAS datasets using SSIS packages and SAS Proc SQL processes
• Created several complex queries, stored procedures, views, functions to process data for the different business units
• Extracted production data to perform data validation using Linked Server methodology
• Responsible to process monthly STOC Subordination, Mortgage, Heloan, Heloc and Loan Performance (LP) data related to the CoreLogic model
• Automated several existing SAS manual processes (CoreLogic, LP, LP Heloan, LP Heloc, Paid Off Loans etc.) using SQL Server and SSIS
• Developed complex queries, joins, sub-queries, cross apply, case statement etc. To translate SAS variables while converting in SQL
• Responsible to convert all the complex transformations from SAS to SQL while automating the SAS processes
• Provided data analysis, reports to validate SAS CoreLogic and LP files and capture issues based on the data validation
• Responsible to perform entire testing and data validation (SAS vs. SQL), develop test cases and issue logs
• Created ETL solution and mapping documents to provide detailed level direction from start to end process
• Responsible to create database Change Management Request (CMR) for the project and logged these CMR in the share point site
• Captured any development, access and data related issues and notify to the ‘Risk Man’ team with the potential solution

Environment: MS SQL Server 2008 R2/2012, SSIS, SAS 9.4, SAS Enterprise Guide - 7.1, Red Gate, SQL Data Compare 11, Share Point 2010, MS Visio 2010, MS Office 2010, Windows 7, Thin Client, Virtual PC

Confidential

Sr. BI / ETL Developer

Responsibilities:

• Analysis the custom files assign to me and developed technical specification based on the mapping document and custom data
• Develop Netezza script using age Aginity tool to upload custom file data
• Responsible to perform normalization based on the custom file data structure to feed proper trade data in the L1 Entitlement table
• Developed several SSIS packages using the AVEKSA SSIS package framework
• Responsible to modify SSIS frame work and package variables, framework set up script and Netezza script for several custom files
• Created different QA branches and deployed SSIS packages in QA
• Responsible to create process flow documentation to show how custom files are captured from staging folder to upload in to L1 level
• Generated views against L1 custom tables so that business can have the access of custom files

Environment: SQL Server 2012, Visual Studio 2010 / SQL Server Data Tools 2010, Netezza Emulator, Aginity, MS Office, MS Vision, TFS

Confidential, New York, New York

Sr. BI Developer / SIS Analyst

Responsibilities:

• Analyze the existing Student Admission and Registration system both from frontend (Jenzabar / EX) and backend database (SQL database)
• Create mapping documents, functional / technical specs to establish the relationship among admission and registration module and how advising module relates with student division and student course history
• Interact with the different program (MD, MD-PhD, Grad School etc) directors, deans and gather requirements to enhance existing Jenzabar system and in corporate new program / curriculum in the EX
• Created several database scripts, tables, stored procedures, view and complex queries using t-sql
• Developed several reports using InfoMaker and SQL Server Reporting Service (SSRS)
• Responsible to create online forms using InfoMaker and add those forms to EX system so that register can use them to enter new / updated course and student information in to EX
• Responsible to review both JIRA and Service Now ticketing system, resolve the ticket either assign on me or any ticket related to Jenzabar backend database (SQL), ad-hoc analysis, access request, report automation etc.
• Created several online Content Forms (CF) and Work Flows (WF) using JICS 8.2 for the different groups such as MD, MDPhD etc.
• Generated views using JICS to capture submitted data, developed reports by capturing JICS form data and finally updated existing Student Course History and Degree History in EX
• Responsible to perform all the validation and QA work against EX and JICS system
• Responsible to provide user access to our reporting database using EX, JICS, InfoMaker and SSRS by creating user account, role and InfoMaker groups

Environment: MS SQL Server 2008 R2/2012, Jenzabar (EX), InfoMaker 11.5, SSRS, Windows 2008 R2, JIRA, Service Now, Mac OS 10.9.5, Office 365, MS Office for Mac 2011

Confidential

Manager / Sr. BI / Data Warehouse Developer

Responsibilities:

• Interacted with the different business units, gather business requirement and involved in daily Scrum meetings and managing the user requirements in providing an efficient work plan
• Analyzed marketing data specially offer's related data and create several documents
• Responsible to arrange and conduct regular meetings
• Gathered and documented Confidential application, conversion and integration requirements
• Responsible of business and technical analysis in the collection and documentation of business and technical requirements gathering for the development of Confidential, Data Warehousing and Reporting implementation roadmaps based on call center and marketing data
• Responsible to create several data marts in SQL Server 2008 R2 / 2005 and pull data from Oracle through SSIS and SAS
• Developed several database scripts, tables, stored procedures, view and complex queries
• Designed and created Report templates, bar graphs and pie charts based on the financial data also scheduled monthly/weekly/daily reports to run automatically
• Involved on Customer Based Marketing (CBM) database migration from SQL Server 2005 to SQL Server 2008
• Responsible for creating the entire ETL/SSIS packages including Staging and data marts using T-SQL
• Developed SSIS transformations including Derived Column, Lookup, Slowly Changing Dimension (both type 1 and 2), Conditional Split, Merge Join, Union All, Aggregate, Script Tasks, Execute SQL Tasks, Package Task, Send Email Task.
• Scheduled JAD Sessions and involved in gathering the report specifications by interacting with the users
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations using T-SQL
• Scheduled & Maintained ETL packages in terms of data validation and consistency
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling
• Deployed the SSIS Packages from development server to production server
• Created SQL Server Agent jobs, SSIS log and Event Handler
• Provided automation for the entire ETL/SSIS package
• Developed several ETL test cases and was responsible for QA testing
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area, then used various SSIS tasks such as Conditional Split, Derived Column, data validation checks during Staging, and finally transfer into data warehouse
• Used Joins and Sub-Queries to simplify complex queries involving multiple tables using T-SQL
• Reviewed and fine-tuned T-SQL stored procedures and triggers before production migration
• Developed new methodologies to create new / existing reports and automate processess
• Created weekly/monthly dashboard report using marketing data (behavioral analysis) of different business units and related offer performance using SSRS, Excel and SAS
• Provided full support on SmartLink application and responsible to update feedback mail box as well as issue log
• Resposible to assign tasks to the other member of the team and also provide solution / assistance if required
• Managed a portfolio of the most complex initiatives that span multiple lines of business and strategic partners understanding the interdependencies between technology, operations and business needs and ensuring consistent use of common processes across all projects following best business practice in ITIL framework
• Managed program plans, deadlines, dependencies across initiatives, risk and coordination of project team activities

Environment: MS SQL Server 2008 R2/2005, SAS, Oracle 10g, Toad, Share Point 2010, Windows, MS Office 2010, SmartLink, ICM, MOP

Confidential

Lead SQL Server BI/ ETL Developer

Responsibilities:

• Analyzed Bitumar’s existing system, source views and developed several functional, technical specs and data mapping documents
• Installed and configured MS SQL Server 2008 R2 in the Development and QA server
• Worked closely with the Architect and SME to finalize the physical design of the warehouse
• Developed database scripts for staging and for the new data warehouse
• Responsible for creating the entire ETL/SSIS packages including Staging and Warehouse using T-SQL
• Developed complex SSIS transformations including Derived Column, Lookup, Slowly Changing Dimension (both type 1 and 2), Conditional Split, Merge Join, Union All, Aggregate, Script Tasks, Execute SQL Tasks, Package Task, Send Email Task etc.
• Used Joins and Sub-Queries to simplify complex queries involving multiple tables using T-SQL
• Reviewed and fine-tuned T-SQL stored procedures and triggers before production migration.
• Created SQL Server Agent jobs, SSIS log and Event Handler
• Provided automation for the entire ETL/SSIS package
• Developed several ETL test cases and was responsible for QA testing
• Managed a portfolio of the most complex initiatives that span multiple lines of business.
• Managed program plans, deadlines, dependencies across initiatives, risk and coordination of project team activities

Environment: MS SQL Server 2008 R2/2005, Windows 2008, MS Office 2010

Confidential

SSIS/ETL Consultant

Responsibilities:

• Responsible for developing all the database backups and restored them in the new development environment using SQL Server 2008
• Developed Dynamic packages using SSIS (using T-SQL) and Implemented Incremental Data Loading
• Performed data mapping and transferred data from staging tables to database tables using SSIS transformations.
• Scheduled & Maintained ETL packages in terms of data validation and consistency
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Deployed the SSIS Packages from development server to production server
• Installed and configured Ataccama DQ Analyzer and connected it with the development database
• Generated extracts for all the new Airline using DQ Analyzer 6.0
• Enabled detail level of table analysis work for each airline, compared and validated the result and extracted against existing airline in the production
• Analyzed the existing ETL packages and developed several lookup transformation based upon product, payment, and promotion

Environment: SSIS, MS SQL Server 2008, DQ Analyzer 6.0, MS Office

Confidential

BI Consultant

Responsibilities:

• Developed detailed technical design document, technical specs test cases for several reports.
• Analyzed the existing reports on Microsoft Dynamics 2009 and performed a gap analysis in order to establish the required report for the department
• Performed X++ code to the existing AX report in order to pull the correct data from the AX database for reporting purposes
• Customized the existing report by developing new displayed methods, adding data source and establishing a relationship inside the fetch method
• Created database backups and restored locally to develop SSRS reports
• Developed several store procedures, views and complex queries to build reports using SSRS 2008

Environment: SSRS, MS SQL Server, Microsoft Dynamics AX 2009, Windows Server, MS Office Suite

Confidential, Atlanta, GA

SQL BI Developer

Responsibilities:

• Developed a data conversion document which provided detailed process flows of the data loaded by the vendors through FTP- AXWAY and DMM (Web portal)
• Loaded the folder to the relational database tables using SSIS jobs Scheduler and Execution and loaded them to the Cube using SSIS jobs
• Reviewed all project documentation including BRD, Business Process Document, Functional and Technical specification documents and updated them as per business request
• Created several test cases and test scripts using Mercury Quality Center 8.2
• Performed UAT, unit testing, integration testing and regression testing for the new Global BI System

Environment: SSIS, SSRS, SSAS, Mercury Quality Center 8.2, MS Share Point 2007, Lotus Notes

Confidential, New York, NY

Sr. SQL Server BI Developer (SSRS/SSIS)

Responsibilities:

• Created a new data warehouse using SQL Server 2005, extracting data from the OLTP to DB2 Reporting database by using SSIS (T-SQL)
• Built Cubes for different stores using SSAS and developed several business reports using SSRS
• Analyzed the existing DB2 database (Reporting database) for different stores
• Created physical and logical structures of the new data warehouse and process work flows
• Created several tables, views and stored procedures using SQL Server 2008/2005 and Toad for DB2 3.0
• Created SSIS packages to extract data from DB2 to the SQL Server and scheduled jobs to call the packages
• Wrote T- SQL queries, Store Procedures and used them to build packages and reports
• Migrated data from SQL Server 2005 to SQL Server 2008 by creating SSIS packages, export and import jobs
• Developed several behavioral reports and data points creating complex SQL queries and stored procedures using SSRS and Excel 2007
• Optimized all indexes, SQL queries and Stored Procedures to improve the quality of the software
• Developed several complex MDX queries and used those to build the reports by using SSRS with T-SQL
• Developed several ad hoc reports using MS Excel 2007/2003 and automated some of the ad hoc reports based on business demand
• Created several SSIS schedule tasks and monitored those tasks regularly
• Used Joins and Sub-Queries to simplify complex queries involving multiple tables using T-SQL
• Reviewed and fine-tuned T-SQL stored procedures and triggers before production migration
• Analyzed the error output and error log of the automated process in case of failure of the process
• Developed a high level daily summary report (Flash Report) and a monthly business summary report (Monthly Management Report)
• Created different traffic channels and analyzed the behavior of the business using different web analytics tools
• Developed several data segments, metrics and reports using Discover and SiteCatalyst and compared reports
• Used SSIS to load data from an email attachment to the SQL database

Environment: MS SQL Server, SSRS, SSIS, SSAS, DB2, SQL Server 2005/2008, Toad, Omniture/SiteCatalyst 14/13.5, Discoverer 2.8, MS Office 2007

Confidential, Atlanta, GA

SQL Server SSRS/SSIS Developer

Responsibilities:

• Extracted data from Safeco Insurance’s claim databases using SSIS and generated different types of reports in the line of business ABI (Auto Bodily Injury) through SSRS
• Gathered requirements, analyzed the CRD (DB2) and CVO (Historical MS Access Databases) and documented the findings
• Developed several data mapping documents and data mining documents
• Created several ABI Reporting databases, tables and Stored Procedures using SQL Server 2005 and T-SQL
• Used Joins and Sub-Queries to simplify complex queries involving multiple tables using T-SQL
• Reviewed and fine-tuned T-SQL stored procedures and triggers before production migration.
• Wrote different complex SQL queries including inner and outer joins and updated queries
• Created several SSIS jobs and packages and executed those tasks

Environment: SQL Server 2005, SSIS, SSRS, DB2, MS Access 2003, Informatica 8.1