SUMMARY

• Over 7+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL,SQL SERVER, UNIX & OLAP.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, temporary tables, views, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and complex queries including correlated queries and queries with complex joins and aggregate functions.
• Excellent hands - on experience with data modeling tool like Erwin and strong knowledge of Relational and Dimensional database modeling concepts with star schema and snowflake schema’s design and implementation.
• Experience in dealing with high volume transactional data in SQL
• CreatedStored ProceduresandT-SQLcodefor complex business logic.
• Very good experience with installation, configuration and migration across different versions of SQL Server 2005/ 2008/ 2008 R2/ 2012.
• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Worked Extensively on ETL process using SSIS package.
• Experience in creating jobs, SQL Mail Agent, Alerts and scheduledDTS and SSIS Packages.
• Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data in partitioned tables in the EDW.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, Bulk Copy Program(BCP).
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS).
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Experience in developing SSIS packages extracting Data from Oracle Database using OLE DB driver for oracle on windows 64bit and 32bit machines.
• Enabled speedy reviews and first mover advantages by using Oozie to automate data loading into the Hadoop Distributed File System and PIG to pre-process the data.
• Managed and reviewed Hadoop log files.
• Developed multiple MapReduce jobs in Java for data cleaning and preprocessing.
• Led the migration of monthly statements from UNIX platform to MVC Web-based Windows application using Java, JSP, Struts technology.
• Received praise from users, shareholders and analysts for developing a highly interactive and intuitive UI using JSP, AJAX, JSF and JQuery techniques.
• Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLTP databases.
• Created dashboards consisting of grids, charts and reports in Performance Point to detail the costs.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from /2008.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008 and SQL 2008 R2.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Provided 24x7 Support to PRODUCTION jobs with OFFSHORE and ON SITE Teams.
• Extensive working knowledge in Application testing, Data Modeling, Data migration, Data Warehousing, and OLTP, OLAP Database projects.
• Created Configurations to make package portable and created Event handlers for handling package error.
• Experience in creating reports through PROCLARITY. Used PROCLARITY for accessing and analyzing cubes and dimensions.
• Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services (SSAS).
• Expert increatingvarious types of reports like reports using Cascading parameters, Complex drill down and drill through reports and charts using SQL Server Reporting Services (SSRS) based on relational and OLTP databases
• Experience with file transfer protocols, including standard FTP and SFTP.
• Experience in Service Broker, Replication data distribution tools
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Good understanding ofRetail,Health careandFinancial Industry
• Experience in Normalization and building Referential Integrity Constraints, Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Experience in Performance Tuning, Query Optimization, Execution Plan, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Hands on experience in trouble shooting database issues.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills. Experience in 24X7 production support, ETL executions and resolving root causes.
• Good understanding ofRetail,Health careandFinancial Industry.
• Experience in Normalization and building Referential Integrity Constraints, Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• I have database administration experience in MSSQL and Vertica. Vertica is a column store database that is very scalable and works especially well in a data warehouse. I pride myself as a relational database specialist and understand the technology behind other relational databases such as MySQL, SQL Server, Microsoft Access 2003.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Worked on the deployment process of the package by using both the File system and MSDB techniques.

TECHNICAL SKILLS

Operating Systems: Windows Vista /XP/NT/2000/98/95, Windows sever 2003, Unix, Linux

Languages: C, PL/SQL, T-SQL, XHTML, Perl, PHP, Java Script, C# .NET

Databases: SQL Server 2012/2008R2/2008/2005, MySQL, Oracle, MS-Access

Database Tools: SQL Server Management Studio, SSIS, SSAS, SSRS, DTS, BCP, Business Intelligence Studio, Enterprise Manager, Query Analyzer, SQL Profiler, crystal reports and Toad for oracle, Informatica Power Center 9.x,8.x, Data stage 8.1/8.0/7.5/7. x, TOAD, IBM Cognos 8

Other Tools: Erwin, Microsoft Visual Studio 2003/2005/2008/2010, Microsoft Visio.

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

MS SQL BI Developer

Responsibilities:

• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• CreatedETL metadata reportsusing SSRS, reports include like execution times for the SSISpackages, Failure reports with error description.
• DevelopedETL jobsto load information intoData Warehousefrom differentrelational databasesandflat files.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Deployed SSIS packages and Reports to Production Servers.
• Developed multiple MapReduce jobs in Java for data cleaning and preprocessing.
• Led the migration of monthly statements from UNIX platform to MVC Web-based Windows application using Java, JSP, Struts technology.
• I have database administration experience in MSSQL and Vertica. Vertica is a column store database that is very scalable and works especially well in a data warehouse. I pride myself as a relational database specialist and understand the technology behind other relational databases such as MySQL, SQL Server, Microsoft Access 2003.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Worked on both the Project and Package Deployment models.
• Regression tested and implemented first in Dev and QA environment.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Experience in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.
• Received praise from users, shareholders and analysts for developing a highly interactive and intuitive UI using JSP, AJAX, JSF and JQuery techniques.
• Developed some scripts in C#.Net used in ETL Process that works as transformation.
• Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package.
• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.
• Created parameterized reports for the brokers and clients.
• Formatted the report layout for the requirement of the end users.
• Deployment of the developed reports on to the server for the end users.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Worked as On Call Support Person to monitor the PRODUCTION Jobs that run in Monthly schedules.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Environment: MS SQL Server 2012/2008R2/2008, SQL Server Reporting Services (SSRS 2010/2008R2/2008), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP, XSLT, XML, Informatica, MDX, Shell Scripting.

Confidential, Allentown, PA

MS SQL BI Developer

Responsibilities:

• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008.
• Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Experience in developing reports using SSRS 2008 and SSRS 2008 R2
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.
• Created data sources, connection strings and defined the datasets for generating the report.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
• Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Worked with VB6 to generate reports.

Environment: T-SQL, PL/SQL, MS SQL Server 2008/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Data Modeling, SQL Server Data Design, Visual Source Safe (VSS), Windows XP, Crystal Reports, VB6, Oracle 10g, VBScript.

Confidential, Cleveland, OH

MS SQL BI Developer

Responsibilities:

• Experienced in creating different types of reports Drill down Reports, drill through reports, parameterized reports, matrix reports, tabular reports, chart reports as per the user request.
• Created Adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Partnered with various Business lines to improve existing reports and create new control reports to reduce errors and streamline the process.
• Provide suggestions to assigned business line to streamline reporting and procedures as necessary.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Pulled the data from DB2 Server by using open queries and SSIS Packages to load data into SQL Server database to create SSRS Reports.
• Creating Indexes and used Scan and Seeks for performance tuning.
• Created dashboard reports (daily, weekly, and monthly) for the upper management to monitor the Home Equity loan performance.
• Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.
• Deployed the report rdl files to the report manger (or) share point site to make report visible for user by using web server link, it’s easy for upper management to view the reports in report manager or share point site.
• Utilized functions in DB2 Queries to concatenate, finding date differences, finding date part, finding part of the string in DB2 Server which are different from SQL Functions.
• Worked on Team Foundation Sever 2008 to store (check in or check out) the sql queries, packages, and reports to share them with the team members. Even if the local system crashes down we can able to use the code from TFS.
• Documented the process (Upper management reports) of pulling the data from DB2 Server and load it into the SQL Server tables, so that it could be used as a training manual for new hires and for audit validations.
• Responsible for interacting with business users to learn the business requirements and business functionality to improve the reporting process.
• Transferred data from various data sources/business systems including MS Excel, MS Access, and Flat Files etc. to SQL Server using SSIS/DTS packages using various features.
• Worked with VB6 to generate reports.
• Utilized different types of task’s (Execute SQL task, Data flow task, For Loop Container, For each Loop Container, Bulk Insert task) to load the data from source to destination based on business requirement with all conditions applied by task functionality.
• Used different transformations (Derived Column, Data Conversion, Condition Split, Lookup transformation, multicast, and script component transformation) under Data Flow Task while pulling and loading data from one source to another source to makes the data clean and consistent.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Environment: Enterprise Manager, SQL Server 2008/2012, Control-M Manager, Visual Studio 2008/2012, SSIS, SSAS, SSRS, VB6, C #, T-SQL, Performance Tuning, Visio 2010, Windows Server 2003.

Confidential, Farmington Hills, MI

SQL Server Developer/SSIS Developer/SSAS Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources.
• Created SSIS packages using transformations like conditional split, data conversion, derived column, lookup, join, merge join, sort, union all, multicast, slowly changing dimension, in SSIS as per the clients Requirement.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Use SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Extensively worked on Data Flow transformations like Foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
• Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Scheduled the SSIS packages to run at different intervals to load the data.
• Configured Server for sending automatic mails to the respective people when a SSIS package fails.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Developed a High level dashboard using SSRS 2008.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Involved in creating report models and applying row level security filters for report model.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: SQL Server 2008R2 Enterprise Edition, SDLC, SQL, T-SQL, MS Access, MS Excel,& Windows 2003 server, Business Intelligent technologies like SSIS,SSRS,SSAS.

Confidential, Los Angeles, CA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• CreatedETL metadata reportsusing SSRS, reports include like execution times for the SSISpackages, Failure reports with error description.
• DevelopedETL jobsto load information intoData Warehousefrom differentrelational databasesandflat files.
• CreatedStored ProceduresandT-SQLcodefor complex business logic.
• Developed some scripts in C#.Net used in ETL Process that works as transformation.
• ConfigureSSISPackage for run time Parameters and Configuration file.
• Created complex scripts to do chucking and massaging of legacy data in staging area of DTS and SSIS package.
• Used variousSSIStaskssuch asConditional Split, Derived Column, which were used forData Scrubbing, data validationchecksduring Staging, before loading the data into theData warehouse.
• Developed an automated report subscription process usingSSRS.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created SSIS Packages for Incremental Loading and slowly changing dimensions.
• ImplementedType 2Slowly Changing Dimensionto maintain Dimension History.
• Created parameterized reports for the brokers and clients.
• Formatted the report layout for the requirement of the end users.
• Deployment of the developed reports on to the server for the end users.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly and monthly reports for the analysis of managers and end users.
• Supported 24/7 for the production system for post deployment Reports on the server.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Calculated members, named sets, and execute other script commands to extend the capabilities of a MS SQL Server 2005 Analysis Services (SSAS) cube.

Environment: MS SQL Server 2008R2/2008/2005, SQL Server Reporting Services (SSRS 2008R2/2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP, XSLT, XML, C#, ASP.Net, Informatica, MDX, Shell Scripting, DTS, MS Visio, UDB, Erwin.