SUMMARY:

• Over 6 years of IT Experience in analysis, design, development, implementation and troubleshooting of Data Mart / Data Warehouse applications using ETL tools like SSIS, OLTP, OLAP, Business Objects, Tableau, Informatica power center, Power BI.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), Star and Snowflake schema design addressing slowly Changing Dimensions (SCDs).
• Experience in developing and maintaining logical and physical Data models for Data Warehouse applications using tools like Erwin and ER/Studio.
• Involved in all phases of data warehouse project life cycle. Designed and developed ETL Architecture to load data from various sources like DB2 UDB, Oracle, Flat files, and XML files, Teradata, Sybase and MS SQL Server into Oracle, Teradata, XML, and SQL server targets.
• Extensive integration experience as Data analyst by gathering data from different sources, data profiling, data definition, and loaded those data on business warehouse. Worked on different kind of source systems and deeply understanding of business and accounting terms and formula.
• Expertise in implementing complex Business rules by creating robust ETL workflows using MS SQL Server Integration Services (SSIS) in a SSDT SQL Server Data Tools 17.0.
• Connections to Azure Analysis Services (AAS), importing and analyzing data from a web page using Power BI Desktop, Composite models, Bidirectional cross - filtering in Power BI Desktop, DXA formula.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. Expertise in Session partitioning and tuning session and lookup/aggregator/joiner caches for performance enhancements.
• Extensively worked with Oracle PL/SQL Stored Procedures, Functions and Triggers and involved in Query Optimization.
• Profound knowledge about the architecture of the Teradata database. Developed Teradata Loading and Unloading utilities like Fast Export, Fast Load, Multiload (Mload).
• Developed BTEQ scripts to Load data from Teradata Staging area to Data warehouse, Data warehouse to data marts for specific reporting requirements.
• Documented design procedures, mapping specifications from Source to Target, operating instructions, test plans/procedures and troubleshooting procedure for ease of application maintenance.
• Good experience in performing and supporting Unit testing, System Integration testing, UAT and production support for issues raised by application users.
• Strong in UNIX Shell and PERL scripting. Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like CRON tab, Maestro, Control-M.
• Deploying Scripts into
• Excellent technical and professional client interaction skills. Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Knowledge of standardized Acord XML formats used in Insurance companies.
• Experienced in Agile methodologies and usage of JIRA Boards.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• Responsible for EDI testing and monitoring for smooth flow of transactions between utility and energy marketers.
• Trouble shooting EDI transactions using a ticketing system.
• Acted as a liaison between the utility and energy marketer for technical documents required for development of application.

TECHNICAL SKILLS:

Databases: Oracle 7.x/8.x/9i/10g/11i, SQL Server 2008/2005/2003/2000 , Teradata V2R4 V2R5, DB2 UDB 7.2 SQL Assistant, My SQL 5.0/4.1, MSSQL, Oracle, Sybase

ETL Tools: Informatica (Power Exchange/Power Center/Power Mart 9.0.1,8.6.1,8.5,8.1.11,)) Informatica Data Quality Workbench 8.5, SSIS)

Data Modeling Tools: ERWIN, ER/Studio, Toad Data Modeler.

Programming Skills: C++, Shell Scripting (K-Shell, C-Shell), PL/SQL, FORTRAN, JAVA (Eclipse IDE and Net Beans IDE), HTML, JAVA Script, J2EE, CSSMethodologies

Data Modeling: Logical, Physical

Dimensional Modeling: Star / Snowflake

Reporting Tools: MS SQL Server Reporting services, SSRS, Tableau (10.3.2), POWER BI

Operating Systems Cloud: UNIX (Sun-Solaris, HP/UX), Windows 95/98/00/NT/X

PPROFESSIONAL EXPERIENCE:

Confidential, Portsmoth, NH

Data Analyst/ Data Modeler

Responsibilities:

• Refining use cases and backlog requirements provided by Product Owner, Business Analysts, Scrum master in creating user stories in JIRA boards from design team.
• Experience in organizing and organizing meetings for understanding business requirements for target DWH design involving SME, Product Owner, Data Architect and BI developers.
• Assisting Data Architect in analyzing source data base systems (Axis, Penta) architectures for designing target data models maintaining the granularity of target dimensional models.
• Creating simple & complex mapping rules to load dimension & fact tables as per STAR Schema techniques.
• Responsible for analyzing simple and complex logic involving calculations of Ceded, Gross, Re-insurance premium amounts for fact tables for Power BI Reporting.
• Organizing data models knowledge transfer meetings for broader audience involving developers and Testing team.
• Experienced in Reverse Engineering/ forward engineering using ERWIN tool.
• Deploying DDL’s for AWS redshift table creation in DEV, UAT, and PROD regions.
• Creating Redshift business views and deploying them into PROD and UAT.
• Responsible providing clarifications for ETL developers on mapping logic for target data model during development phase.
• Experienced in clearing UAT and PROD release defects in order to improve on the quality of the product and meet the project milestones within timely manner.
• Experience in developing Bidirectional cross-filtering in Power BI Desktop, Shape and combine multiple data source, importing and analyzing data from a web page using Power BI Desktop.
• Analyzing data from excel and an OData feed, connect with Power BI Desktop (DXA formula compatibility in Direct Query Mode).
• Experienced in highlighting priorities, deadlines and blockers in Scrum meetings for completion of user stories.
• Solid understanding of Business Process definition, Risk Analysis and Agile methodologies.

Environment: ERWIN, Sybase, Oracle, AWS Redshift, Microsoft Excel, Bit Bucket, Share Point, JIRA.

Confidential

Data Modeler

Responsibilities:

• Responsible for designing a staging data model for automatization of processing policy enrolling files and loading them into legacy systems.
• Involved in various JAD meetings for converting Business level specifications into Data specifications/data models.
• Involved in sessions of Data Governance for processing manual files.
• Experience in business process data modeling using forward and reverse engineering concepts in ERWIN.
• Review of Data Models with entire team.
• Deploying DDL scripts into DEV, UAT, and PROD regions.
• Experience in preparing Mapping documents for integration of new data files to the already existing legacy systems.
• Responsible for creating Data Dictionaries for different Hanover products (HHC, MPL, LPL).
• Responsible for deploying data models to enterprise data model repositories.
• Experience working with global teams.
• Gained knowledge of Acord XML files used in Insurance domains.
• Experience working in software cycles (water fall method).

Environment: ERWIN, Oracle, DB2, Microsoft Excel, Acord XML.

Confidential

Sr. Data Analyst.

Responsibilities:

• Responsible for gathering business requirements.
• Developing new classification rules for the available data sets.
• Creating classification data models using classification Transformation in Informatica Data Quality (IDQ).
• Design, Development and implementation of Informatica Developer Mappings for data cleansing using Address validator, Labeler, Parser, Expression, Filter, Router, Lookup transformations etc.
• Extensively used Informatica Functions LTRIM, RTRIM, DECODE, ISNULL, IIF,IS DATE in data cleansing that is coming from legacy.
• Effectively worked on Repository Manager, Mapping Designer, worklet manager, Workflow Manager, and Monitor
• Evaluate effectiveness of already existing classification rule sets and present recommended modifications to improve system performance.
• Extensively used the Teradata utilities like BTEQ, Fastload, Multiload, DDL Commands and DML Commands (SQL).
• Responsible for monitoring automated BTEQ scripts and troubleshooting log errors.
• Performed tuning and optimization of complex SQL queries using Teradata Explain and Run stats.
• Created a BTEQ script for pre-population of the work tables prior to the main load process.
• Created Primary Indexes (PI) for both planned access of data and even distribution of data across all the available AMPS. Created appropriate Teradata NUPI for smooth (fast and easy) access of data.
• Involved in regressive testing of ETL workflows and classification transformation models for better score cards.

Environment: SQL Server, T-SQL, ETL, Teradata, Microsoft SQL Server, Microsoft Excel, Informatica 9.X, Informative Data Quality (IDQ), Informatica Life Cycle Management, Power BI.

Confidential, Long Island, NY

Sr. Data Analyst .

Responsibilities:

• Conducted major stakeholder meeting involving SME's, business analysts, and other stakeholders
• Designed, developed and implemented ETL framework using SSIS, stored procedures, functions for extractions into SQL Server.
• Responsible for EDI testing and monitoring for smooth flow of transactions between utility and energy marketers.
• Trouble shooting EDI transactions using a ticketing system.
• Acted as a liaison between the utility and energy marketer for technical documents.
• Worked with various utilities file formats like Coned, NYSEG, PSEG.
• Created SSIS Packages for data transfer between servers, load data into database, and archived data file from various heterogeneous sources like SQL Server, Excel and CSV.
• Worked with IDQ on data quality for data cleansing, robust data, remove the unwanted data, correctness of data.
• Design and generation of different database objects like Tables, Views, Synonyms and Sequences, Pl/SQL packages and database Triggers.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, analyze using OLAP tools).
• Develop reports using the Teradata advanced techniques like rank, row number and etc.
• Created report schedules, data connections, projects, groups in Tableau server.
• Implemented Agile Methodology for building an internal application.
• Designed and developed consolidation process for number of MS SQL servers within the firm.

Environment: SQL Server, Tableau Server, PL/SQL, ETL, Teradata, SSIS, TSQL, SharePoint, Power BI, Power Pivot

Confidential, Melville NY

Sr. ETL Developer

Responsibilities:

• Involved in Data mapping specifications to create and execute detailed system test plans
• Analyzed business requirements, system requirements, for documenting functional requirements and supplementary requirements in Quality Center.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Designed the business requirement collection approach based on the project scope and the SDLC using Agile methodology.
• Wrote and executed SQL queries to verify that data has been moved from transactional system to DSS, Data warehouse, DataMart reporting system in accordance with requirements.
• Trouble shooted test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Responsible for different Data mapping activities from Source systems to warehouse.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.
• Developed PL/SQL programs, stored procedures for data loading and data validations.
• Involved in analyzing the source data coming from different data sources such as XML, DB2, Oracle, flat files.
• Extensively worked on Shell scripts for running SAS programs in batch mode on UNIX.
• Followed company code standardization rule.
• Tested Cognos reports to check whether they are generated as per the company standards
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved based on using defect reports.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various database
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing.
• Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Oracle 11g, PL/SQL, SQL Loader, SQL Reports, Tableau, DB2, UNIX Shell Scripting, XML, MS Office, MS Visio, MS Word.

Confidential, LA, CA

ETL Designer/Developer

Responsibilities:

• Involved in Database modeling, ETL and creation of analytical processes, responsible for translating the Business requirements into technical specifications.
• Experience of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using ERWIN.
• Responsible for creating OLAP models based on Dimensions and Facts for efficient loads of data.
• Developed Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task, and different data flow tasks using SSIS packages.
• Created various geographical and time dimension reports of fiscal year, quarter, month, week and daily reports for all domains and published through Report Server.
• Responsible for generating annual reports based on the growth of company with respect to customers.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.

Environment: SQL Server, Tableau Server, PL/SQL, ETL, Teradata, SSIS, TSQL, SharePoint, Power BI.