SUMMARY

• More than 7 years of extensive experience in development using Microsoft Technologies SQL Server 2008/2012, MSBI projects with extensive usage of ETL & Reporting tools like SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS) and SQL Server Analysis Services (SSAS)
• Worked as a BI developer in multiple projects. Designed ETL packages and reports as per teh client requirements.
• Well versed in SQL Server 2008/2012 database design.
• ExcellentT - SQL Development skills. Knowledge of optimizing T-SQL using Execute Query Plan.
• Excellent Designing, Programming, and debugging skills.
• Experience in Creating, Scheduling and Maintaining SQL Server Job Agents.
• Created SSAS cubes, dimensions, attributes and measures. Experience of creating hierarchies and relationships among dimensions and facts, aggregation, KPIs, measures and deploying and Processing SSAS cubes.
• Experience in software configuration management using SVN, Git.
• Involved in teh Quality Assurance Team and actively participated in peer review.
• Equally efficient and productive working on large scale and highly integrated systems through teh different phases of Software Development Life Cycle (SDLC) as an individual and also team member.
• A Quick learner, Self-starter, highly motivated individual possessing strong analytical power, problem-solving abilities.
• TEMPEffective team player and excellent communication skills with insight to determine priorities, schedule work and meet critical deadlines.

TECHNICAL SKILLS

Programming: SQL, PL/SQL, Java

Microsoft Applications: SSIS, SSAS, SSRS

Databases: SQL Server, Oracle

Tools: SQL Server 2008 R2, 2012, SQL Server BIDS, Qlikview, Rapid Miner, SAS E Miner, R, Google Analytics, Confidential Boomi ETL

Software Packages: MS Office Suite, MS Project, MS Visio, Bugzilla

Development Methodology: Agile, Waterfall

Configuration Management: Git, SVN

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Business Intelligence Consultant

Environment: SQL Server 2012, SSIS, SSAS, SSRSQuickstart Data Warehouse

Responsibilities:

• Working on end to end BI project. Working closely with functional team to get teh requirements.
• Creating SSIS packages to load data from source db to staging area. Used Data Transformations like Multicast, Data Conversion, and Derived Columns.
• Used SQL Server Agent to run teh packages on teh server.
• Validated teh data on teh test cases written, used SQL joins to validate teh data.
• Fixed defects identified during testing.
• Using SSRS to create various reports for each of teh subject areas to meet teh clients requirements.
• Created parameterized reports using SSRS to avoid excessive data showing up on teh reports.
• Worked with teh data modeler, to determine teh facts, dimensions and design a star schema.
• Creating SSAS cubes to understand and analyze patterns of teh customers.
• Provided consulting services to clients on teh TEMPeffectiveness of Quickstart Data Warehouse product.
• Good understanding of Quickstart Data Warehouse' architecture.
• Good understanding of new features of SQL Server 2012 like Columnstore Indexes etc.
• Worked on a product called Mirth Connect, to extract data from hl7 files, transform it and load it onto different destinations.
• Interacted with other teams to understand teh business needs, created teh packages, performed testing, fixed defects identified during testing and presented it to teh team.

Confidential, New York

Summer IT Intern

Environment: Qlikview, SQL Server 2008

Responsibilities:

• Interacted with teh client to understand exponential smoothing, calculated teh baseline sales.
• Regular meetings with teh client to understand teh requirements.
• Documented teh requirements and various methodologies used in teh project for further reference.
• Designed data visualization, 20 reports, for promotional TEMPeffectiveness data analytics project using Qlikview.
• Performed unit testing on teh data loaded in Qlikview, ran teh reports on sample data to ensure teh correctness of teh reports and then ran it on teh entire data.
• Actively participated in agile workshops.

Confidential, New York

Summer IT Intern

Environment: SQL Server 2008, SSIS, SSAS

Responsibilities:

• Analyzed teh raw dump of data using teh metadata documents to understand different entities and establish relationship between them.
• Worked closely with teh client to ensure teh issues identified during data analysis are resolved.
• Built SQL queries to validate teh correctness of teh relationships established amongst teh entities.
• Used SSIS to gather data from excel files and load it onto SQL Server. Used data transformation tasks like Data Conversion, Derived Columns, and Multicast to prepare data for predictive maintenance model for a Railway client.
• Performed unit testing after running teh SSIS packages to load teh data.
• Wrote complex SQL queries for verifying teh data.
• Used SQL Execute query plan to analyze teh query performance and optimize it.

Confidential, Arizona

Business Intelligence Analyst, Graduate Assistant

Environment: SQL Server 2008, SSIS, SSRS, Joomla, Drupal

Responsibilities:

• Interacted with department heads to understand teh pain points.
• Imported data from various sources: flat files, excel.
• Analyzed teh data, identified teh relationship between teh various entities involved and created a data model.
• Used transformations to apply rules to teh data loaded from teh source files.
• Wrote test cases and tested teh loaded data for each of teh test cases. Fixed defects identified while testing.
• Developed parametric reports, drilldown reports, and sub reports to meet teh requirements.
• Generated teh reports weekly, monthly, quarterly, and yearly basis as per teh requirements.
• Administrator of teh department website. Regular meetings with department heads and other members to update content and improve layout of teh department website.
• Facilitate migration of data from Joomla to drupal. Train staff members on drupal.

Confidential, Princeton, NJ

System Analyst

Environment: SQL Server 2008, SSIS, SSRS, SSAS

Responsibilities:

• Interacted with teh client team to determine teh requirements.
• Determined scope of teh project phases and documented teh mappings.
• Identified teh various sources where data resided and wrote ETL plans to load data from these sources.
• Extracted data from various sources like SQL Server 2008, Oracle, .CSV, Excel and Text file from Client servers and through FTP
• Teh packages created included a variety of transformations, for exampleSlowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Multicast and Data Conversion.
• Used Execute Query Plan to analyze teh performance of SQL Queries
• Performed and fine-tunedStored Procedures,SQL QueriesandUser Defined Functions.
• Identified and solved numerous technical and operational problems in teh Data mart design and ETL implementations.
• Identified teh granularity level of teh data available for analysis.
• Determined teh facts and dimensions and worked closely with teh data modeler to define teh dimensional model.
• Created SSAS cubes. Simplified and Optimized OLAP requests by using Aggregates and Hierarchies.
• Building and generating reports with teh help of Report Builder in teh Report manager.
• Created parameterized, drilldown reports to allow teh user to look at data based on user inputs and giving teh user a snapshot of data at various hierarchical levels.
• Created event handlers per teh package using event handler tab.

Confidential

Programmer Analyst

Environment: DB2, unix, Microsoft SQL Server 2008, SSIS, Microsoft Excel

Responsibilities:

• Participated in teh calls with teh onsite team, gathered requirements.
• Run scripts on a weekly basis to load data from teh landing databases to teh local database.
• Extracted data from landing directories, filtered teh data, created various reports.
• Interacted with teh onsite team to determine teh rules to load data for teh current period.
• Based on teh rules determined, created packages and used various transformation tasks I like derived columns, data conversion etc. in SSIS.
• After teh loading teh correct data, created reports in teh healthcare format and sent it to teh state.
• Based on teh corrections from teh state, new format files were submitted to teh state again.
• Created various reports, ran awk scripts on a monthly basis to understand teh changes and include teh numbers in reports.
• Worked on enhancements, debugging and fixing bugs
• Involved in deploying and scheduling SSIS packages
• Generated teh reports on a weekly and monthly basis as per teh client requirements.
• As per teh requirements rendered teh reports in teh pdf, excel forms.

Confidential

Programmer Analyst

Environment: SSIS, Vignette tool, Microsoft Excel

Responsibilities:

• Participated in teh calls with teh onsite team, gathered requirements.
• Run scripts on a weekly basis to load data from teh landing databases to teh local database.
• Extracted data from landing directories, filtered teh data, created various reports.
• Interacted with teh onsite team to determine teh rules to load data for teh current period.
• Based on teh rules determined, created packages and used various transformation tasks I like derived columns, data conversion etc. in SSIS.
• After teh loading teh correct data, created reports in teh healthcare format and sent it to teh state.
• Based on teh corrections from teh state, new format files were submitted to teh state again.
• Created various reports, ran awk scripts on a monthly basis to understand teh changes and include teh numbers in reports.
• Worked on enhancements, debugging and fixing bugs
• Involved in deploying and scheduling SSIS packages.
• Worked closely with other teams to ensure that teh deployment went successfully.
• Generated teh reports on a weekly and monthly basis as per teh client requirements.
• As per teh requirements rendered teh reports in teh pdf, excel forms.

Confidential

Intern

Environment: SSIS, SQL Server 2005

Responsibilities:

• Prepared technical design documents as per teh requirements given by teh client.
• Extensively used SSIS to load data from different data sources into teh data warehouse.
• Involved in data cleansing and extraction.
• Created physical tables, defined joins and implemented authorizations in teh physical layer of teh repository.
• Imported Sources and Targets created Mappings and developed Transformations using SSIS.
• Created complex mappings and transformations using expressions, aggregators, filters, sorter, sequence generator, connected and remote lookups to develop and populate Data Marts.
• Fine-tuned Transformations and Mappings for better performance.
• Extensively used control flow tasks and data flow tasks to design teh packages.
• Performed unit testing on teh data loaded via SSIS packages.
• Reviewed teh packages developed by co-interns.