SUMMARY

• IT Professional with 7+ yearsof professional experience in design, modelling, development, testing, implementation, and support of enterprise data warehouse/BI in domains like Insurance, health, banking, retail, etc.
• Experience in all phases of Software Development Life Cycle (SDLC) on both Agile/Waterfall Methodologies including requirement gathering, Analysis/Design, Development, Testing, Reporting.
• Experience in designing, Implementation of Data warehousing and Business Intelligence (BI) using ETLtools like SAS, Talend, SQL, Informatica Power Center.
• Experience in SAS programming and data analysis in Windows, Linux.
• Work experience includes very close interactions with Business Users, Technology group, Project Team and QA Analysts.
• Experience in maintenance, enhancements, performance tuningofETL code.
• Experienced inworkingwith business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional technical and technical design specifications.
• Experience using python scripting for data analytics and data visualization tools like Tableau.
• Strong Experience in Relational Data Modeling & Dimensional Data Modeling to deliver Normalized Data Models & Star and Snowflake schemas using CA Erwin 9.6, ER Studio 7.1.
• Experience in working on different Databases like Oracle, Vertica, AWS Redshift, SQL Server etc.
• Excellent Knowledge on Slowly Changing Dimensions (Type1, Type 2, Type 3), Change Data Capture, Dimensional Data Modeling, Star/Snowflake Modeling, OLAP and FACT and Dimensions tables, Physical and Logical data modeling.
• Excellent analytical, problem solving, communication and inter - personal skills to manage and interact with individuals at all levels.
• Always keen and eager to face up to challenges by means of novel and innovative ideas.
• Effective team player with strong communication and interpersonal skills

TECHNICAL SKILLS

Operating Systems: UNIX, WINDOWS 98/2000/NT/XP.

Languages: SQL, PL/SQL, SAS, Base SAS, SAS/Macro, SAS/SQL, HTML, JAVA, XML, Python, UNIX shell scripts, C, C++.

Databases: Oracle 10g,11G, AWS Redshift, MS SQL Server, MS Access 2000, Teradata, Vertica.

BI Analytics/ Tools: SAS EG, SAS DI ETL, Informatica,Erwin, Talend Enterprise Edition 5.5.1.,SSIS, Tableau, Python, SQL

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg PA

Data Modeler/Analyst

RESPONSIBILITIES:

• Worked as an onshore development resource for the AWS migration.
• Created draftdatamodels for understanding and to helpDataModeler.
• Resolved thedatarelated issues such as: assessingdataquality,dataconsolidation, evaluating existing datasources.
• Worked on the migration of Legacy ETL to Talend in AWS on worked on the analysis resolution of production defects.
• On shore development resource performing execution, defect resolution complete end to end cycle execution in UNIX development environment.
• Worked as a bridge resource for smooth transition of activities between internal teams QA, UAT, DA, DBA onshore and offshore teams.
• CreatedDatamapping, logicaldatamodeling, created class diagrams and ER diagrams and used SQL queries to filterdata.
• Gathered requirements and modeled thedatawarehouse and the underlying transactional database
• Worked on reverse engineering for validating the source to target documents (S2T)from the existing code.
• Worked on activities related to preparing, reviewing documents such as version related release documents, operational documents, CR documents, ETL playbooks.
• Leading efforts on the activity of validating the existing source to target document as a part of onboarding new clients or as a part of rewriting the existing ETL code in talend.
• Worked with the agile scrum teams, Project Management team to prioritize business, information and reporting needs.
• Experience in maintenance, retrieving, enhancements, committing and deploying the code in GITHUB and SVN.
• Designed conceptual, logical & physical data models, data dictionaries and metadata repositories.
• Worked with the Project Management team to prioritize business, information and reporting needs.
• Coordinated with DBA’s in creating and managing Tables, Indexes, and Table spaces, Sequences, Views and Materialized Views.
• Worked on complex SQL Queries for performance tuning, space utilization,dataintegrity and consistency across entire application development.
• Experience in TableauVisualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, etc. and other making use of Actions according to the end user requirement.
• Experience working with CRM Systems like Salesforce.
• Performed Metadata & Data Dictionary Management, Data Profiling, Data Mapping, DDL & DML generation & usage.
• Developed, improved and supported enterprise data standards, data architecture policies and procedures.
• Monitored and enforced compliance of data standards to minimize data redundancies and enhance information quality throughout the organization.

Environment: SAS/Base, SAS Enterprise Guide, SAS DI, SQL/PLSQL, Putty, Erwin, Tableau,GITHUB, Vertica, AWS, Windows 7, Talend DI, Squirrel UNIX.

Confidential, NC

Data Modeler

RESPONSIBILITIES:

• Experienced in the software development process, including requirements gathering, analysis and design for various healthcare projects.
• Involved in business presentations, reviewing and organizingdata, with the help of Tableau desktop.
• Extracted various data from the Oracle database using SQL pass through facility and created study specific SAS datasets, which are used as source datasets for report generating programs.
• Analyzed large volumes of dataand develops medium to complex reports/dashboards, insights for clients. Has an in-depth understanding of the tools used for analysis, reporting and developing business insights. Involved in creating reports and dashboards using various charts with Tableau.
• Migration of SAS codes from legacy systems to Unix SAS and with relational databases.
• Used SQL Assistant to analyze and query from the Teradata DB. Worked on IDR (Integrated Data Repository) Database (i.e. a Teradata warehouse) for claims related data.
• CreatingDataDictionary for the model.
• Maintain the database anddatamodel for any further requirements and changes.
• Redesign and extend thedatamodel for further enhancements.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modelling.
• Used PL/SQL Procedures and Functions for modifying the data in the database.
• Also responsible for writing load scripts to load the data into the Sybase IQ tables.
• Handled files having many missing values and special characters and generated datasets based on the conditional requirements of the special character and missing values present in the file raw data files.
• Experience migration of SAS ETL, SAS Enterprise Data Integration Server to Talend ETL tool.
• Involved in the creation of Informatica mappings to extractingdatafrom oracle, Flat Files to load in to Stage area.
• Workeddatamapping,datacleansing, program development for loads, anddataverification of converteddatato legacydata.
• Revieweddataflow diagram to illustrate wheredataoriginates and howdataflows within the EnterpriseDatawarehouse (EDW).
• Converted the Objects andDatafrom the DB2 database to SQL Server.
• Actively involved in designing and developing daily, weekly, monthly, quarterly and yearly ETL (Extract, Transform and Load) processes for different business streams and wrote complex korn Shell scripts to automate ETL processes and send out a notification emails to concerned people.
• Analyzed, designed and developedSASprograms in UNIX platform and transferred and migrated data from one platform to another to be used for further analysis.
• Experienced in writing executive summaries and management reports to clients.
• Presented walk through of GPRO and annual management reports to clients.

Environment: Oracle 11g, Teradata 14.10, Sql Assistant, Tableau, Talend, Erwin, Windows 7, Sql/PL/Sql UNIX,.

Data Analyst /Modeler

Confidential, VA

Responsibilities:

• Worked closely with various business teams in gathering the business requirements.
• Involved in the requirement gatherings and analysis in support of Data Warehousing efforts.
• Developed and validated data models against the business and data requirements and also ensured the quality, accuracy, integrity, and conformity to standards of all models.
• Extensively used Star Schema methodologies in building and designing Dimensional Data Models.
• Coordinated with DBA’s in creating and managing Tables, Indexes, and Table spaces, Sequences, Views and Materialized Views.
• Experience working on migrating the data from legacy application to Oracle Sterling Data Base.
• Reverse engineered existing database schemas in order to implement changes and updates for existing tables and views.
• Worked with a broader Master Data Management team to ensure product life-cycle development process is adhered.
• Had gone through the design and implementation of enterprise data and Meta data structures, also developed and enforced best practices for master data management and integration.
• Implemented metadata standards, data governance, master data management, ETL, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling.
• Used normalization techniques to organize data efficiently in a database.
• Involved in building and maintaining Data modelling, Fact Tables, Dimensions and joined them to extract meaningful data.
• Created Source to Target Mapping documents and High Level Design Documents.
• Provided support to development, testing team and reporting team to ensure that the output of reports is valid and accurate.

Environment: MS Excel, MS Access, shell scripting, MS Power Point, Erwin, MS Word, SQL Plus, SSIS/SSRS, Oracle 10g/11g

ETL Data Analyst

Confidential, MI

Responsibilities:

• Involved unit and integration test for the Informatica and database level.
• Created technical specifications, mapping documents and managed test cases.
• Participated in development of an estimation tracking tool for level of effort projections.
• Gathered information, compiled findings and prepared management reports for staffing levels.
• Developed database applications for managing IT staffing requirements and monitoring the status of outstanding requisitions.
• Written several complex SQL queries to validate the dataconditions as per the mapping document.
• Provided dataanalysis, identified trends, summarized results and generated reports for Card Solutions Delivery reorganization effort.
• Extracted datafrom different sources like, Oracle, Flat files, Xml & loaded into Operational dataSource and tested the same.
• Extensively used SQL and PL/SQL Procedures and Worked in both UNIX and Windows environment.
• Worked on loading of datafrom several flat files to XML Targets.
• Created UNIX shell scripts for Informatica ETLtool to automate sessions.
• Developed graphic representation of various metrics used in the forecasting, budgeting and procurement processes for the Merchandising Department.
• Utilized Access database to collect datafrom multiple database sources using ODBC methods.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Responsible for Unit Testing of the Mappings created according to the business requirements.

Environment: Oracle, SQL, PL/SQL, SQL*Plus Windows 2000/NT/98/95, Microsoft office 97, Erwin, Informatica, UNIX, Shell Scripting, XML

ETL Analyst

Confidential

Responsibilities:

• Responsible for data analysis, data cleansing, coding, testing, and ad hoc reporting.
• Coded programs for generating new reports and did documentation for the existing code.
• Participated in client requirement sessions to analyze and gather business requirements.
• Configured scripts to monitor activity with database.
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
• Helped in maintaining an effective documentation process to track the version control and requirement changes.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Collaborated with Business teams in the creation of the Functional Design document and Source to Target Mapping document.
• Understanding the process and Interacting with functional team to resolve the issues in the given objects.
• Involved in Code Review and User Acceptance Testing (UAT) of the application.

Environment: Oracle 11g/10g,Informatica, Sql Loader, Toad, Windows 7, UNIX,, Windows, Mainframes Z/OS, Unix Oracle, MS office.