SUMMARY

• Having more than 9+ years of extensive IT experience in Data warehousing out of which 7+ years into Microsoft ETL (SSIS,SSRS,SSAS) - 2000/2005/2008 R 2/2012/2014/2017 and BI and 3 + years into Informatica and Pentaho Data integration and Talend . Mostly involving in Data Warehousing, which includes my contribution in the phases of Understanding the business requirement, and developing the ETL Process.
• Good Experience on AGILE and SDLC methodology and Team foundation server(TFS)
• Good experience in developing BI applications utilizing Power BI,BI Stack
• Experience on data warehousing tools, worked at different geographical locations- UK and Dubai
• Responsible for all activities related to the development, implementation, Conversion and Testing of ETL Process for large-scale data warehousing projects
• Well equipped in performing ETL operations with DTS 2000, SSIS 2005,R2,2012, 2017 versions and Informatica Power Center 9.1,9.5
• Proficient in using Power BI
• Involved in unit testing and helped Quality Assurance Team to generate Test Plans and Test Executions.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Designed and developed Power BI graphical and visualization solutions based on business requirement.
• Expert with the backend data retrieval team, data mart team to guide the proper structuring of data for Power BI reporting.
• Developed complex reports using SSRS and deployed into MS CRM.
• Experienced in migrating reports from Crystal Enterprise to SSRS.
• Extensive experience in creating SQL Server analysis projects using MS SQL Server.
• Experienced in creating complex SSIS and DTS packages for ETL purposes.
• Implemented complicated transformations to be used in SSIS packages.
• Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS).
• Well-versed with database installation, configuration, maintenance, monitoring, backups and recoveries, and developing stored procedures and triggers.
• Competent in XML, Fetch XML, HTML5, CSS, JavaScript, SQL Server, SSIS and SSRS.
• Highly proficient in the use of SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, RDB models, data dictionaries, and data integrity, SQL joins and query writing.
• Worked with different data bases like Oracle, MYSQL, SQL Server & Flat files.
• Having good experience in Informatica designer/workflow manager/workflow monitor
• Having good experience in administration like installation and creating configurations and deployment and managing jobs and alerts and repository services and web services
• Having working knowledge ETL Testing.
• Good knowledge on Data modeling (dimensional & Relational) concepts like Star-Schema modeling, Snow Flake modeling, fact and dimensional tables
• Very good Team player with interpersonal communication skills.
• Good academic and professional career.
• Experience in various domains (Sales, Insurance, research, Survey Programming).
• Experience in Research and Insurance domain (Automobile survey for morpace, CATI and mystery surveys) with Morpace client.
• Excellent in designing SSIS packages and SSRS reports and Cube design in SSAS (also involved in security levels for SSS packages, SSRS reports, Cube designs and also implemented logging).
• Experience on Creating stored procedures and views and CDC and TDE
• Involved in POC for new clients HDFC, Shoppers Stop, and Invendis using SSIS, 1 Key Agile.
• Attended various trainings (Informatica, Cognos 10,1 Key Agile,Informatica ILM)

TECHNICAL SKILLS

ETL Technologies: SSIS,DTS and Informatica Power Center 9.1 and Pentao Data integration

BI: SSRS,Cognos,1 Key Agile/ Power BI

Programming: JavaScript, SQL, HTML, UNIX/MDX/DAX

Architecture & Design: Star Schema, Snowflake schema, Dimensional Modeling

Databases: SQL Server 2005, 2008 R2, 2012, MS Access, MYSQL, Oracle 10G

Tools: Tortoises, Subversion, Microsoft Visio, Microsoft Visual Studio.NET, SQL Workbench, Third Party tools for SQL Server Team foundation server, Quality Center, Microsoft Lync, Toad, SSMS,Power view/Power BI

Scheduling Tools: Autosys,SQL Agent,TWS( Tivoli Work Scheduler)

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL & Database Developer

Responsibilities:

• Available from your computer and tablet devices (iPad, Xoom, Galaxy, etc)
• Currently used by all of Customer Service, BGCO, Fraud, Financial Services
• Midwest CS, Northeast CS, South CS, West CS, BGCO, Fraud, Financial Services
• This equates to approximately ~25,000 users
• Provides the simplicity yet flexibility of the administration processes that allows each administrator to quickly create and adapt the tool customized to their specific area needs.
• Integrated with other VZW owned applications for simple access (VZWeb, Enterprise Web Portal, InfoManager, etc)
• Understanding the business requirements & TDD.
• Optimizing the performance of queries with modifications in T-SQL queries, removing-necessary columns, and eliminate redundant and inconsistent data.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view.
• Developed Power BI reports and dashboards from multiple data sources using data blending.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Publishing Power BI reports on dashboards in Power BI server.
• Developed analytics solutions by defining and translating business requirements into dashboard &reporting solutions and implementing them within Microsoft Power BI Desktop and visualizations deal with the backend data retrieval team, data mart team to guide the proper structuring of data for Power BI reporting.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Power BI. Accurate Data Models; adding the calculated DAX measures on top of the datasets wherever required.
• Responsible to manage data coming from different sources.
• Added required measures, calculated columns, keeping unnecessary columns hidden from reporting view in Power BI application.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS.
• Created/Updated database objects like tables, views, stored procedures, function, packages.Designed MS SSIS Packages to extract data from various OLTP sources to MS SQL Server.
• Involved in various stages of agile methodologies like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation
• Responsible for designing, developing, maintaining and enhancing MyInfo application
• Responsible for execution of the Unit, Integrated & User Acceptance testing
• Working on ETL Environments in Dev, Test and Production domains
• Working with Support to solve various SSIS issues faced by Team
• Worked on Performance issues in SSIS
• Designed and optimized data mart schemes in order to handle the dimensions and measures required
• Prepared extensive documentation of the different jobs & processes involved.
• Responsible for development of the extraction programs for the required modules based on the mapping information provided.
• Developing stored procedures for ETL application (Source Systems) to get the required data from External Sources.
• Provide ad hoc support to the MyInfo ETL Team (application) to analyze the telesales systems and data mapping between different applications.
• Technically involve in different phases of migration that includes OLTP and OLAP Modules.
• Actively Participate in Technical Design Documents
• Fine-tuning Stored Procedures to improve performance that was achieved by removing
• Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the manager of Sales department, if the entire field were not entered by the data entry person regarding screening using SQL Server Agent.
• Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.
• Involved in migration of Data from Excel, Flat file, Oracle, files to SQL Server by using BCP and DTS utility.
• Problem and Incident management ensuring that ensure SLA’s are achieved and client expectations are met
• Suggest permanent solutions to avoid the reoccurrence of the incidents.
• Responsible for analysis of the ETL Jobs (Daily, Weekly, Monthly, Web Upload) running on different UAT/PROD servers.

Confidential

Senior MSBI/DB/Power BI Developer

Responsibilities:

• Involved in various stages of agile methodologies like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation
• In depth analysis on data issues to address user queries.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Created live Dashboards and reports using Power BI and published.
• Strong team player and self-motivated
• Designed SQL SSIS Packages to extract data from various data sources such as spreadsheet, flat files, Oracle into SQL Server for further Data Analysis and Reporting.
• Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, merge join, execute SQL flow task, data flow task to extract data from different databases and flat files
• Performed data quality analysis using advanced SQL skills.
• Performed backend testing and made sure the product met user requirement
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing).
• Coding & Debugging, Sorting out their time-to-time technical problems
• Tuned performance for large data files by increasing block size, cache size and target based commit interval

Senior MSBI/Power BI Developer

Confidential, Illinois, Chicago

Responsibilities:

• Involved in various stages of agile methodologies like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Created Clustered index and Non-clustered for increasing performance.
• Developed custom reports and deployed them on server using Power BI.
• Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for data cleansing and data massaging.
• Developed, updated and maintained various reports in Report Builder3.0 for company clients. Built simple reports to more complex reports utilizing parameters for user customization. Some reports fed off existing SQL stored procedures or queries while others needed a new query or stored procedure to be built to pull the data.
• Updated and maintained reports by fixing bugs in already existing queries and/or stored procedures and added functionality to reports by updating current code to accommodate user/client requests, and used the tools in Report Builder to give the reports a nice aesthetic.
• Deployed reports with Report Builder to report site, and used Report manager to modify reports to add recipients to report distribution list.
• Designed the ETL processes using Data Integrator to load data from multiple databases like SQL Server, and Flat Files (Fixed Width) to staging database and from staging to the target Data Warehouse.
• Created metadata driven solution for ETL.
• Developed Source to Target Mapping as per the requirements
• Installed SQL Server 2008R2 with the latest service packs.
• Migrated Database from SQL Server 2008R2 to 2012 by using side by side migration.
• Created tables, indexes and designing constraints.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Used various SSIS tasks such as Conditional Split, Derived Column etc, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Worked with ETL to implement the slowly changing transformation, to maintain Historical Data in Data warehouse and also implemented SCD TYPE 1,II
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers. Enhanced and deploying the SSIS Packages from development server to production server.
• Wrote stored procedures for report generation in SQL Server2008R2.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Administrated the created Reports by assigning permission to the valid user for executing the reports. Rendered reports, managed subscriptions, created reports with report builder, report snapshot and report Cache.
• Created metadata driven tasks using C# (Script Task).
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012
• Used that ODBC source to connect with HDInsight as a source
• Created and Maintained Database Maintenance Plans.
• Strong team player and self-motivated
• Coding & Debugging, Sorting out their time-to-time technical problems
• Tuned performance for large data files by increasing block size, cache size and target based commit interval

Requirement Gathering, Design, SSIS and SSRS Developer

Confidential

Responsibilities:

• Interacted with Business team for gathering, and understanding the client requirements to design the ETL Packages
• Developed Source to Target Mapping as per the requirements
• Actively participated in the Installation& configuration of ETL in Development & Production Server
• Experienced in MSBI Installation with Oracle 12C, SQL Server Database 2012
• Involved in Administration of ETL Services.
• Migration of all SQL based data sources to Cosmos (big data platform) to enable campaign creation via tool.
• Development of SSIS packages, stored procedures and jobs for creating a pipe between cosmos and SQL.
• Created ETL Data Flows for dimension and fact tables and loaded the data into legacy targets in Enterprise Data Warehouse and other systems.
• Created multiple reports using SSRS report builder and published into different applications.
• Worked on report subscriptions
• Worked on Page colors on report level
• Tuned performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, control flows, and data flows.
• Dynamically fetched data for FTP using Script task(C#.net)
• Created Packages for Transaction processing using containers as For Each Loop, Sequence & controlling flow of data using tasks as Script, Data Flow, File System, Execute Package, Execute Process.
• Created Reusable packages having modular structure which can be reused in other packages.

MSBI Developer

Confidential

Responsibilities:

• Understanding the business requirements & TDD.
• Involved in various stages of agile methodologies like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation
• Attending daily standup meeting and sprint planning meeting and sprint review meetings,Retro
• Creation, manipulation and supporting the SQL Server Database.
• Created and updated Stored Procedures and to take care of back end validations when transferring data to Production Server.
• Extensively involved in designing the DTS to SSIS packages to make the automated synchronization of data from one system to another system.
• Created Data warehouse Cubes in SQL Server Analysis Service (SSAS).
• Configured SQL Server 2000 in-built log shipping from primary server to secondary server.
• Analyzed and implemented backup and database maintenance plans.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing
• Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the manager of Sales department, if the entire field were not entered by the data entry person regarding screening using SQL Server Agent.
• Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.
• Involved in migration of Data from Excel, Flat file, Oracle, files to SQL Server by using BCP and DTS utility.

Data warehousing Consultant

Confidential

Responsibilities:

• Understanding the business requirements & TDD, Prepared the specification documents for individual transformations customization
• Involved in various stages of SDLC like gathering User requirement and System Specification. System Analysis, Design, Development, Testing and Implementation
• Creation, manipulation and supporting the SQL Server Database.
• Created Stored Procedures and to take care of back end validations when transferring data to Production Server.
• Extensively involved in designing the DTS to SSIS packages to make the automated synchronization of data from one system to another system.
• Created Data warehouse Cubes in SQL Server Analysis Service (SSAS).
• Scheduled and maintained routine jobs, tasks, and alerts. For instance an alert would be sent to the manager of Sales department, if the entire field were not entered by the data entry person regarding screening using SQL Server Agent.
• Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes. that was achieved by removing
• Prepared Unit Test Cases and Review Log.