SUMMARY

• Over 10 years of IT experience in Sr. ETL/BI Developer, Design, Development, System Analysis and Support of MSSQL Server 2016,2014,2012,2008 R2, 2005, 2000, 7.0, MS - Access in Development, Test, Production and Replication & Clusterenvironments.
• Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SSRS, Power BI for developing reports of different type. SQL ServerReporting Services (SSRS).
• Knowledge of Relational Database Management systems and Data Modeling.
• Worked on configuring Service Broker for message Queuing system.
• Experience in Database Backup, Logshipping, Replication Recovery and Disaster Recovery procedures.
• Experience with Data Transformation Services, Batch processes, Import/Export and Backup/Restore.
• Experience in Performance Tuning, Query Optimization, Client/ ServerConnectivity, Database Consistency Checks using DBCC Utilities.
• Hands on experience in Troubleshooting database issues.
• Use SQL Azure for maintaining application databases (Storage, Container).
• Experience in writing and debugging Stored Procedures, Views, triggers, Functions using T-SQL Scripts
• Extensive experience in creating business, functional and technical documentation.
• Excellent verbal, written communication and presentation skills, problem solving and conflict resolution skills.
• Maximum Team Handle on Onsite to Offshore range between 10 -35 including Manager as Team Lead.
• Experience on working with .Net and Java Applications.

TECHNICAL SKILLS

RDBMS: MS SQL Server 6.5, 7.0,2000, 2005 and 2008, 2008 R2,2012,2014,SQL AZURE DB2, MS Access 2000/97and Oracle.

Programming: C, C#, C++, PL/SQL, T-SQL, Java, Java Script, COBOL, ASP, HTML Perl script, and Visual Basic, PowerShell, PowerB1, AWS SQL Clouding

Operating Systems: Windows 2000, Workstation, Windows NT/XP/95/98, MS DOS, UNIX

Applications: MS Office, MS Visio, Dream Weaver

Tools: Erwin, NetIQ, TFS, Clustering, Remedy, Attunity, NT Performance monitor/System monitor, TSQL, SQL Profiler, SQL Query Analyzer, OSQL, JIRA

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OHIO

Sr ETL Developer/BI Developer

Responsibilities:

• GatheringBusiness Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Dimension Modeling design. Design Dimension and Fact Tables Especially Star Schema for creating Fact and Dimension tables.
• Developing SSIS package for incremental and full loading of data to Data warehouse.
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Deployment, scheduling and Running SSIS packages on SQL server Catalog.
• Creating dynamic SSIS packages along with XML configuration file.
• Creating SSIS packages for importing data through different data sources (Excel, CSV, SQL, Oracle, Teradata).
• Use TFS for code Versioning.
• Writing PL/SQL script for retrieving data from Oracle databases.
• Developing SSIS by using Merge join, Conditional Split, pivot or Unpivot task to output the data by using complicated logics.
• Writing Expression for Dynamic parameter generated during run time of SSIS packages.
• Security of SSIS packages.
• Use Power BI tools to create Data Sets for Reports like Matrix, Tabular, Drilldown, Navigational, Parameterized, sub reports, pie -charts.
• Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.
• Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Implemented code check-in/check-out and managed multiple versions of complicated code within TFS.
• Error Handling, Package Logging and Configuration of packages
• Use TFS for code Versioning.
• PL/SQL code using TOAD for retrieving data from Oracle.
• Creating indexes (Clustered and Non-Clustered) for improving the server performance
• Creating cubes, performance of cubes for MOLAP storage option.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Scheduling and working on performance of reports.

Environment: MS SQL SERVER 2016 R2, 2012, MS SQL SERVER 2008 R2, SQL Server 2005, Oracle, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003, Excel 2003, Windows NT/2003.

Confidential, Louisville Kentucky

Sr ETL Developer/BI Developer

Responsibilities:

• Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages by using Fuzzy looks up task
• Use Winscp for the pulling and pushing the files to SFTP server
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Deployment, scheduling and Running SSIS packages on SQL server.
• Creating dynamic SSIS packages along with XML configuration file.
• Creating SSIS packages for importing data through different data sources (Excel, CSV, SQL, Oracle, Teradata).
• Writing PL/SQL script for retrieving data from Oracle databases.
• Developing SSIS package for incremental and full loading of data to Data warehouse.
• Developing SSIS by using Merge join, Conditional Split, pivot or Unpivot task to output the data by using complicated logics.
• Writing Expression for Dynamic parameter generated during run time of SSIS packages.
• Security of SSIS packages.
• Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.
• Translated the business requirements into workable functional and non-functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.
• Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis
• Optimized report performance with caches and snapshots.
• Use SQL Azure for maintaining application databases (Storage, Container). Backup using SQL BLOG.
• Error Handling, Package Logging and Configuration of packages
• Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.
• Involved in Writing MDX query for creating Datasets for SSRS reports.
• Use Power BI tool to create Data Sets for different types of reports like Pie chart, Dashboard, navigational drilldown reports from different sources like CSV, EXCEL, SQL etc.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.

Environment: MS SQL SERVER 2014, Oracle, MS SQL Server 2005/2008, SSIS, SSRS, Power BI, Microsoft Visual Studio 2012, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, NYC

Sr ETL Developer/BI Developer

Responsibilities:

• Involved in GatheringBusiness Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Migration from Oracle to SQL Server 2012.
• Involved in writing T-SQL script for databases and tables.
• Data Migration from Oracle to SQL Server 2008R2.
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Scheduling and deploying the packages on SQL Server.
• Creating cubes, performance of cubes for MOLAP storage option.
• Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.
• Involved in Writing MDX query for creating Datasets for SSRS reports.
• Use Power BI tool to create Data Sets by creating power views from different sources like CSV, EXCEL, SQL ETC.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Creating cubes, performance of cubes for MOLAP storage option.
• Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.
• Involved in Writing MDX query for creating Datasets for SSRS reports.
• Use Power BI tools to create Data Sets by creating power views from different sources like CSV, EXCEL, SQL ETC.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Error Handling, Package Logging and Configuration of packages
• Scheduling and deploying the packages on SQL Server.
• Use TFS for code Versioning.
• Involved in creating Custom and Matrix reports Pie charts as well by SSRS.
• Developed Parameterized, Navigational, Sub reports, Tabular Reports using dataset created from OLTP Database to Cubes.
• Involved in creating both Data and Dimensional Modelling for designing Databases for OLTP and OLAP system.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Scheduling and working on performance of reports.
• Involved in implementing the data model using .Net Applications.

Confidential, New Jersey

Sr ETL Developer/BI Developer

Responsibilities:

• Writing T-SQL script for databases and tables.
• Creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Creating parameterized as dynamic reports from cubes using Expressions.
• Deployment, scheduling and Running SSIS packages on SQL server.
• Building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Scheduling and deploying the packages on SQL Server.
• Creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in Error Handling, Package Logging and Configuration of packages
• Creating cubes, performance of cubes for MOLAP storage option.
• Use TFS for code Versioning.
• Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.
• Involved in Writing MDX query for creating Datasets for SSRS reports.
• Use SSRS tools to create Data Sets by creating power views from different sources like CSV, EXCEL, SQL ETC.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Creating DTS Packages to import & export data from text files MS SQL Server databases
• BCP in and out of data from one environment to another environment.
• Production support for all kind of technical issues.
• Improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.

Confidential, Jersey City

Sr ETL Developer/BI Developer

Responsibilities:

• GatheringBusiness Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Writing T-SQL script for databases and tables.
• Creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Scheduling and deploying the packages on SQL Server.
• Creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Creating parameterized as dynamic reports from cubes using Expressions.
• Deployment, scheduling and Running SSIS packages on SQL server.
• Creating DTS Packages to import & export data from text files MS SQL Server databases
• Creating cubes, performance of cubes for MOLAP storage option.
• Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.
• Involved in Writing MDX query for creating Datasets for SSRS reports.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• BCP in and out of data from one environment to another environment.
• Use TFS for code Versioning.
• Production support for all kind of technical issues.
• Improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Created the backup schedule for production, test and development servers.
• Involved in creating Table Partioning for large tables by Partition Schemas and Partition Functions
• Involved in creating indexes (Clustered and Non-Clustered) for improving the server performance

Confidential, OH

Sr ETL Developer/BI Developer

Responsibilities:

• Building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Writing T-SQL script for databases and tables.
• Creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Scheduling and deploying the packages on SQL Server.
• Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.
• Creating Attributes and Dimension hierarchy in cube
• Creating Cubes and Hierarchies between different attributes and Dimension.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Writing MDX query against cubes to browse data and creating reports from Cubes.
• Writing Calculations, named sets, KPI, Translation for cubes to use them for reports and browsing data
• Creating cubes, performance of cubes for MOLAP storage option.
• Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.
• Involved in Writing MDX query for creating Datasets for SSRS reports.
• Use Power BI tools to create Data Sets by creating power views from different sources like CSV, EXCEL, SQL ETC.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Involved inGatheringBusiness Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• DTS Packages to import & export data from text files MS SQL Server databases
• Creating Dynamic and parameterized reports using expression and mdx query from cube.
• Writing shell scripting for UNIX data
• Custom and Matrix reports as well Pie charts by SSRS.
• Created the backup schedule for production, test and development servers.

Confidential, Ohio

Sr ETL Developer/BI Developer

Responsibilities:

• Developing SSIS package for incremental and full loading of data to Data warehouse.
• Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages by using Fuzzy looks up task
• Data Migration from Oracle to SQL Server 2008R2.
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Deployment, scheduling and Running SSIS packages on SQL server.
• Creating dynamic SSIS packages along with XML configuration file.
• Creating SSIS packages for importing data through different data sources (Excel, CSV, SQL, Oracle, Teradata).
• Writing PL/SQL script for retrieving data from Oracle databases.
• Developing SSIS by using Merge join, Conditional Split, pivot or Unpivot task to output the data by using complicated logics.
• Writing Expression for Dynamic parameter generated during run time of SSIS packages.
• Security of SSIS packages.
• Use TFS for code Versioning.
• Error Handling, Package Logging and Configuration of packages
• Dimension Modeling design. Design Dimension and Fact Tables especially Star Schema for creating Fact and Dimension tables.
• Creating cubes, performance of cubes for MOLAP storage option.
• Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.
• Involved in Writing MDX query for creating Datasets for SSRS reports.
• Use Power BI tools to create Data Sets by creating power views from different sources like CSV, EXCEL, SQL ETC.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• PL/SQL code using TOAD for retrieving data from Oracle.
• Creating indexes (Clustered and Non-Clustered) for improving the server performance
• Creating cubes, performance of cubes for MOLAP storage option.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Scheduling and working on performance of reports.
• Creating DTS Packages to import & export data from text files MS SQL Server databases.
• Improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.

Environment: MS SQL SERVER 2008 R2, SQL Server 2005, Oracle, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003, Excel 2003, Windows NT/2003.

Confidential, Iowa

Sr ETL Developer/BI Developer

Responsibilities:

• GatheringBusiness Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages by using Fuzzy looks up task
• Developing SSIS for moving data from Oracle to SQL databases.
• Deployment, scheduling and Running SSIS packages on SQL server.
• Creating dynamic SSIS packages along with XML configuration file.
• Creating SSIS packages for importing data through different data sources (Excel, CSV, SQL).
• Developing SSIS by using Merge join, Conditional Split, pivot or Unpivot task to output the data by using complicated logics.
• Writing Expression for Dynamic parameter generated during run time of SSIS packages.
• Error Handling, Package Logging and Configuration of packages
• Dimension Modeling design. Design Dimension and Fact Tables especially Star Schema for creating Fact and Dimension tables.
• Creating cubes, performance of cubes for MOLAP storage option.
• Creating perspective, translation KPI, Calculations using MDX query.
• Creating Cubes and Hierarchies between different attributes and Dimension.
• Creating cubes, performance of cubes for MOLAP storage option.
• Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube .
• Involved In Writing MDX query for creating Datasets for SSRS reports.
• Use Power BI tools to create Data Sets by creating power views from different sources like CSV,EXCEL,SQL ETC.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Optimization of cubes by Aggregations, Partitions of cubes
• Error Handling, Package Logging and Configuration of packages
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Developing customized reports like Matrix, Flat reports

Environment: MS SQL SERVER 2008 R2, SQL Server 2000, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Philadelphia

Sr ETL Developer/BI Developer

Responsibilities:

• Writing PL/SQL script for retrieving data from Oracle databases.
• Building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Scheduling and deploying the packages on SQL Server.
• Error Handling, Package Logging and Configuration of packages
• Creating Web Config File OR Tables for storing all variables for Security purpose.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Involved in Database Design and implementation. Created and maintain databases after logical and physical database design through Visio Tool.
• Involved in writing T-SQL script for databases and tables.
• Involved in Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Involved in Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.
• Involved in creating Attributes and Dimension hierarchy in cube
• Involved in creating Cubes and Hierarchies between different attributes and Dimension. Creating cubes, performance of cubes for MOLAP storage option.
• Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.
• Involved in Writing MDX query for creating Datasets for SSRS reports.
• Use Power BI tools to create Data Sets by creating power views from different sources like CSV, EXCEL, SQL ETC.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Involved in Creating parameterized as dynamic reports from cubes using Expressions.
• Involved in writing MDX query against cubes to browse data and creating reports from Cubes.
• Involved in writing Calculations, named sets, KPI, Translation for cubes to use them for reports and browsing data
• Involved in optimization of cubes by Aggregations, Partitions of cubes
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Involved in creating Table Partioning for large tables by Partition Schemas and Partition Functions
• Involved in creating indexes (Clustered and Non-Clustered) for improving the server performance
• Involved in Deployment, scheduling and Running SSIS packages on SQL server.
• Involved in production support for all kind of technical issues.

Environment: MS SQL SERVER 2005,2008 R2, SQL Server 2000, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003, Excel 2003, Windows NT/2003.

Confidential, Seattle

Sr ETL Developer/BI Developer

Responsibilities:

• GatheringBusiness Requirements, understanding workflow, Impact Analysis and Technical Specification Documentation.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Scheduling and deploying the packages on SQL Server.
• Error Handling, Package Logging and Configuration of packages
• Create database objects including tables, triggers, views, stored procedures, Indexes, CTE (Common Table Expressions), and Functions.
• Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.
• Creating Attributes and Dimension hierarchy in cube
• Writing MDX query against cubes to browse data and creating reports from Cubes.
• Use TFS for code Versioning.
• Writing Calculations, named sets, KPI, Translation for cubes to use them for reports and browsing data
• Deployment, scheduling and Running SSIS packages on SQL server.
• BCP in and out of data from one environment to another environment.
• Creating Dynamic and parameterized reports using expression and mdx query from cube.
• Creating cubes, performance of cubes for MOLAP storage option.
• Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.
• Involved In Writing MDX query for creating Datasets for SSRS reports.
• Use Power BI tools to create Data Sets by creating power views from different sources like CSV, EXCEL, SQL ETC.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Writing shell scripting for UNIX data
• Improving the performance of cubes by creating aggregations, partition of cube.
• Creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Created the backup schedule for production, test and development servers.
• Involved in creating indexes (Clustered and Non-Clustered) for improving the server performance
• Involved in Database Design and implementation. Created and maintain databases after logical and physical database design through Visio Tool.

Environment: MS SQL SERVER 2005, 2008 R2, SQL Server 2000, Oracle, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003, Excel 2003, Windows NT/2003.

Confidential, Dayton, OH

Sr ETL Developer/BI Developer

Responsibilities:

• Database Design and implementation. Created and maintain databases after logical and physical database design.
• Create database objects including tables, triggers, views, stored procedures, indexes.
• Involved in Data cleansing, Extraction, Transformation and Loading of Data through SSIS packages
• Involved in writing PL/SQL code using TOAD for retrieving data from Oracle.
• Involved in data migration from DB2, Access data source to SQL Server.
• Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Involved in building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Involved in scheduling and deploying the packages on SQL Server.
• Involved in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
• Involved in writing package for incremental load to the data warehouse.
• Involved in creating and development of cubes and hierarchies between their attributes.
• Involved in improving the performance of cubes by partition and creating aggregation of cubes.
• Involved in creating paramertized and Dynamic reports using expressions from cube.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Creating cubes, performance of cubes for MOLAP storage option.
• Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube .
• Involved in Writing MDX query for creating Datasets for SSRS reports.
• Use Power BI tools to create Data Sets by creating power views from different sources like CSV, EXCEL,SQL ETC.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Involved in creating Table Partitioning for large tables by Partition Schemas and Partition Functions
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in creating indexes (Clustered and Non-Clustered) for improving the server performance
• Involved in creating strategies for Backup and Restore of Prod databases.
• Involved in creating DTS Packages to import & export data from text files MS SQL Server databases
• Involved in production support for all kind of technical issues.

Environment: MS SQL SERVER 2005, 2008 R2, Oracle, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential, Columbus, OH

ETL Developer/BI Developer

Responsibilities:

• Migration of 2000 Databases to 2005 Databases. Migration include the migrating the SQL 2000 DTS packages to SQL server 2005 SSIS packages
• Created Packages for synchronization of Production Databases to UAT, SIT, DEV Databases, Tables comparison, Row-by-Row comparison.
• Involved in Tuning Store Procedures and query optimization for SQL server 2005
• Involved in Creating and Altering Tables, Triggers, Views, Stored Procedures, Functions and Indexes.
• Involved in creating SSIS package for loading data from different Data sources (MS Access, Excel SQL 2000).
• Involved creating SSIS packages for Full and incremental loading of data for building Data warehouse.
• Involved in building developing Dynamic SSIS package and writing expression to for dynamic parameter.
• Error Handling, Package Logging and Configuration of packages
• Creating Table Partitioning for large tables by Partition Schemas and Partition Functions
• Involved in data mapping from DB2 to SQL Server 2008.
• Creating indexes (Clustered and Non-Clustered) for improving the server performance
• Involved in Database tuning by using DTA (Database Tuning Advisor) and other third-party tools
• Involved in Designing Dimensional modelling specially Star Schema for creating Fact and Dimension tables.
• Creating cubes, performance of cubes for MOLAP storage option.
• Involved in writing MDX query in SSAS management Studio for Slicing and Dicing of Cube.
• Involved in Writing MDX query for creating Datasets for SSRS reports.
• Use Power BI tools to create Data Sets by creating power views from different sources like CSV, EXCEL, SQL ETC.
• Creating Expressions and Dynamic variables in SSIS.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Creating Attributes and Dimension hierarchy in cube
• Creating Cubes and Hierarchies between different attributes and Dimension.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Writing MDX query against cubes to browse data and creating reports from Cubes.
• Involved in writing Calculations, named sets, KPI, Translation for cubes to use them for reports and browsing data
• Involved in deployment of code in all the environments (SIT, UAT, PROD) and troubleshooting any technical issue

Environment: MS SQL SERVER 2005, 2008 R2, 2000, MS SQL Server 2005/2008, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003, Excel 2003, Windows NT/2003.

Confidential, Seattle, WA

ETL Developer/BI Developer

Responsibilities:

• Gathering business requirements from users and doing impact analysis and delivering it to the offshore team for development
• Reviewed code and deployment guide prior to release to testing team.
• Involved in deployment of code in all the environments (SIT, UAT, PROD) and troubleshooting any technical issue
• Migration of existing Application from 32 bits to 64 bits environment including installation of Performance Point Server 2007 (PPS).
• Created dimensions and Hierarchies in Performance point server for user interface and loading the data at SQL server Backend through SSIS packages.
• Designing Dimensional modelling especially Star Scheme.
• Involved in creating Cubes and Hierarchies between different attributes and Dimension.
• Creating parameterized as dynamic reports from cubes using Expressions.
• Creating Custom and Matrix reports as well Pie charts by SSRS.
• Involved in importing XML data from XML Document to SQL Server through XML Nodes and XML query.
• Resolved bugs during testing cycle of application.
• Development of features like optimization, security, and audit log in existing application.
• Involved in creating Custom and Matrix reports as well Pie charts by SSRS.
• Created a POC and given presentation on Master data management (MDM) to business users as a future implementation for the current Performance Point (PPS) application.
• Worked on SQL Server Integration Services Packages (SSIS) and PPS for loading the data into the SQL Server databases.
• Monitored and created tasks and bugs in MS visual studio Team Foundation Server (TFS, also VSTF) and assigned to proper authorities (offshore development team, test team, etc).
• Performed impact analysis during design changes in upstream and downstream systems.
• Design the application context diagram using MS-Visio tool Installed, configured and maintained

Environment: MS SQL SERVER 2005, 2008, 2000, MS SQL Server 2005/2008, SSIS, SSRS, SSAS, Microsoft Visual Studio 2008, SQL Profiler, Microsoft Visio, MS Office 2003, Excel 2003, Windows NT/2003.