SUMMARY:

• Seasoned technical professional with over 15 years of strong experience in Information Technology as a Business/System Analyst, UAT Analyst, Data Migration Consultant, BI Developer, ETL Developer and Mainframe Developer
• Strong knowledge across the domain of Data warehouse, Business Intelligence, Web based applications and Enterprise Mainframe applications; across several industrial sectors like Banking, Cable, Re - Insurance, Credit Processing, Finance, Logistics and Automobile for enterprise clients
• Strong experience with Agile Software development, Waterfall Methodologies and SOA
• Expertise in the domain of DW/BI with Agile principles to deliver innovative business intelligence, reporting and analytic solutions.
• Experience in a Scaled Agile Framework (SAFe) program environment
• Extensive experience working with stakeholders to manage product expectations and product delivery timeline.
• Experience with creating User stories, Business requirement document (BRD), Business Process flows (BPF), Use Case diagrams and Functional Requirement ( Confidential ) document.
• Effectively collaborated cross-functional teams of developers, business analysts, quality analysts, clients and vendors.
• Excellent knowledge in Data Analysis, Data Flow diagram (DFD), Data lineage, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Proficient with a variety of agile project management tools like Rally (CA), JIRA, Confluence
• Extensive experience with Data Modeling, Relational Database Concepts, Entity Relation diagrams and Normalization concepts
• Sound understanding of normalized OLTP database, Kimball Data Warehouse methodologies, Dimensional and Multi-Dimensional (Cube) Modeling
• Extensive experience in ETL/ Data warehouse backend testing and BI reports Acceptance Testing
• Strong experience in Data Quality Analysis using various tools and writing/tuning complex SQL queries against various databases including Oracle, DB2, Teradata and SQL Server
• Extensive experience in developing SQL scripts to validate the databases and reports data
• Participated in SQA audits for CMM Level 5 organization
• Demonstrated ability to work and communicate effectively in a global Onsite/Offshore environment with technical and business audiences
• Dynamic and assertive team player with strong commitment

TECHNICAL SKILLS:

Methodologies: Agile (Scrum/SAFe), Waterfall, V-model and RAD

Business Intelligence: Cognos 8.4, Pentaho BI 3

Metadata Management: Ab initio Metadata hub

ETL: Informatica 8.6, Pentaho Data Integrator 3, Pervasive Data Integrator

Databases: Oracle 11g, Microsoft SQL Server 2008, IBM DB2 10, IMS, Teradata

Client server: Power Builder

ERD Tool: Power Designer 12, ERwin

Language: HTML, Java script, Java, Shell scripting, SQL, PL/SQL, T-SQL

Project Management: Confluence, MS Project 2010, PowerPoint, Visio, Excel 2010

Mainframe: COBOL, CICS, IMS, Revolve. File-Aid, Xpeditor, QMF

OS: Windows, UNIX, Linux

Big Data: Cloudera Hadoop, Hive (HSQL), Impala, Oozie

Defect Management: HP ALM/QC, Jira, Bugzilla

Web Service Testing: SOAPUI

Version Controllers: SVN tortoise, Visual Source Safe, Clear Case, GIT

Testing Procedures: Functional, Unit, White Box, Black Box, System, Integration, Regression, Performance, UAT, Data Validity, Smoke

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Business Data Analyst

Responsibilities:

• Collaborate with credit risk business stakeholders to define and prioritize Retail bank risk project features to maximize value.
• Prepared Low level data integration design documents for Moody’s model integration & Wholesale portfolio model.
• Collaborate with the development team & external teams to define, accept and adapt stories.
• Involved with data profiling from multiple external and internal data sources and answered complex business questions by providing data to business users.
• Coordinated release meeting with business stakeholders.
• Created source to target data mappings, data feed specifications, data flows, business rules and data definitions.
• Participated in Release Planning & Sprint planning for business and technical stories
• Validated Test Cases and Test Scripts for data validations.

Methodology: Agile (Scrum/SAFe), Jira

Environment: Rally, Cloudera Hadoop, HIVE, Impala, HSQL, SAS, Netezza, Teradata, Oracle, Autosys, Oozie

Confidential, Charlotte, NC

Business System Data Analyst

Responsibilities:

• Collaborate with business stakeholders across business areas like Care, Call Management, Tech Operations, Billing Operations, Commercial BI, Payment Services & Finance BI to define and prioritize project features to maximize value delivered to business partners
• Collaborate with the development team & external teams to define, accept and adapt stories.
• Responsible for maintaining product backlog with well-defined user stories and acceptance criteria for 2-3 iteration.
• Managed Sprint priorities with incremental delivery of features over multiple releases, minimizing time-to-market.
• Exposure to basic Hadoop concepts
• Involved with data profiling from multiple sources and answered complex business questions by providing data to business users.
• Coordinated sprint release meeting with business stakeholders.
• Prepared Context level Data flow diagram (DFD) for operational system.
• Created source to target data mappings, business rules and data definitions
• Documented end-to-end (Data Lineage) from all business elements to support enterprise wide Metadata management with Metadatahub.
• Defined Data Quality checks requirements to improve data quality.
• Coordinated with downstream team for data cleaning to ensure data is analyzable.
• Guided the Release Planning & Sprint planning for business and technical stories
• Developed Test Cases and Test Scripts for data validations.
• Managed defect scheduling in the backlog.
• Provided day-to-day tactical direction for the team.

Environment: Rally, JIRA, Confluence, Netezza, IDR, AS400, Informix, Teradata, SQL Server, DB2, Oracle, Tidal Job Scheduler, Ab initio Metadata hub (Mhub)

Confidential, Charlotte, NC

Business Data Analyst

Responsibilities:

• Responsible for creating well-defined user stories with acceptance criteria.
• Collaborating with business partners and cross-functional teams and supporting system documentation
• Responsible for documenting functional requirements ( Confidential ) with Use Case diagram ( Confidential ) and supplementary requirements
• Involved in designing the Database model that support web service application.
• Involved in daily Scrum-Stand up meeting, Backlog refinement meeting, Retrospective meeting and Sprint Planning Meetings
• Coordinated key functional delivery to coincide with the stakeholders calendar
• Developed User Acceptance testing (UAT) of web-services.
• Managed the product backlog for 2-3 sprints
• Managed backlog and oversaw development along with an offshore development team
• Reverse engineered source system databases using open source tools.
• Responsible for defining and accepting user stories
• Worked closely development/QA team to make sure acceptance criteria’s are met and the software meets project objectives/customer expectations as defined by the product owner.

Environment: Java, XML, UNIX, Oracle, SVN, Amazon Web Service, JIRA, Confluence

Confidential, Portland, OR

Sr. Business System Data Analyst

Responsibilities:

• Collaborate with business product owner on the vision and roadmap for the platform
• Created Business process flow (BPM) diagrams for logistic system.
• Converted business requirements (BRD) into Technical solutions documents (TSD).
• Extensive SQL querying on Staging, Data warehouse and Data Marts
• Performed Data Count Validation, Data Analysis, and Data Quality Validation in Data Migration
• Responsible for organizing Functionality Test Plans which was utilized by the testing team during a testing process.
• Worked with business stakeholders and Scrum development teams by managing solution delivery expectations and keeping information flowing in both directions
• Communicating necessary changes and development to stakeholders in meetings
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality
• Tracked and reported issues to project team and management during UAT cycles
• Contributed in the development of knowledge transfer documentation

Environment: Data stage 7.0, Oracle 9i, DB2, SQL Server, Cognos, SQL Server, Excel Pivot

Confidential, Memphis, TN

Sr. Business System Analyst / DA analyst

Responsibilities:

• Worked closely with Business user in understanding the process & documenting the Functional requirement ( Confidential )
• Analyzed Client line data to ensure the transactions were correctly implemented and anomalies within the data were investigated and resolved in a timely manner
• Written ETL transformation specifications including test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications
• Developed detail user acceptance cases to ensure complete coverage with positive and negative test conditions
• Involved in designing and preparing test scenarios, test plans, test cases and test data
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle
• Performed Data Analysis and developed Data Mapping documents.
• Developed Test Cases and SQL Queries to perform various Validations
• Performed Count Validation and Data Quality Validation in Data Migration
• Analyzed various reports generated by Cognos for data accuracy.
• Checked the reports for any naming inconsistencies and to improve user readability

Environment: Informatica, DB2, UNIX, Cognos, Windows Server 2003, Quality Center

Confidential, Moline, IL

Sr. UAT Analyst

Responsibilities:

• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Created and executed test cases based on test strategy and test plans based on ETL mapping document
• Tested complex ETL mappings and reusable transformations for daily data loads
• Created test cases for ETL mappings and design documents for production support
• Wrote complex SQL queries for querying data against different data bases for data verification process
• Utilized SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Defects identified in testing environment where communicated to the developers using defect tracking tool
• Set up, monitored and used Job Control System in Development/QA/Prod
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Scheduling and automating jobs to be run in a batch process
• Effectively communicated testing activities and findings in oral and written formats
• Worked with ETL group for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and SQL Server
• Worked on issues with migration from development to testing
• Extensively tested several Cognos BI reports for data quality, fonts, headers & cosmetics

Environment: Oracle, Informatica Power Center (Power Center Designer, workflow manager, workflow monitor), SQL, Cognos 7.0 Series, Oracle8i, TOAD, PL/SQL

Confidential, Detroit, MI

Sr Data Analyst

Responsibilities:

• Developed complex SQL queries for data validation for verifying the ETL Mapping Rules
• Performed Metadata Analysis by Data Profiling and acted as a data steward in maintaining the quality metrics on a continuous basis
• Conducted Data Migration and Data Cleansing
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatics Workflow Manager
• Responsible for Import and Export databases between Microsoft Access, Microsoft Excel, Text, or SQL
• Extensively tested the reports for data accuracy and universe related errors
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Validated the data of reports by developing SQL queries in SQL Developer against Data Mart tables and ODS
• Involved in user training sessions and assisting in UAT (User Acceptance Testing)
• Wrote data conversion and data migration scripts for ETL process
• Created ETL execution scripts for automating jobs
• Involved in extensive DATA validation using SQL queries and back-end testing
• Worked on creating various reporting using crystal reports according to end user requirements
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica PowerCenter, XML, SQL Server 2000, TOAD, MVS, BIRT, Crystal Reports, Oracle 9i, PL/SQL, IBM DB2, Microsoft Visio 2003, MS Excel, Flat Files.

Confidential, Portland, OR

Sr. Data Migration Consultant

Responsibilities:

• Worked with SME's from 4 different companies in data mapping their legacy system to iwarranty software product
• Preparation of Technical Specification and Source to Target mappings document for development team
• Analyzed the business process and user requirements to cater their needs for reporting
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules for data loads
• Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly
• Validated the data of reports by developing SQL queries in SQL Developer against Data Mart tables and ODS
• Oversaw the historical data migration in UAT and PROD environments
• Develop complex ad hoc SQL scripts to analyze data, and develop reports for tracking trends and transactions
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Involved in extensive DATA validation using SQL queries and back-end testing
• Performed in depth testing for all development/enhancements, including data analysis for verification of accuracy and performance tuning for optimal execution

Environment: Informatica, Db2, Oracle, SQL Server, UNIX

Confidential, Findlay, OH

Cognos BI Developer

Responsibilities:

• Collaborate with SME’s, business and technical team to document reporting requirements
• Created cognos models and Publishing Packages using Framework Manager
• Created Dashboards using List, Crosstab, and Graph reports
• Carried out Bursting of reports in Report Studio
• Used Report Studio and Analysis Studio to build reports based on cubes built in Power play Tran former and deploying the cube in Cognos 8
• Created Score carding and Dash boarding reports using Metric Studio
• Worked to transition application into Production Environment by providing support and training through the release cycle

Environment: Cognos 8.4(Report Studio, Analysis Studio, Event Studio), Informatica 7.1, Oracle 10g