SUMMARY

• Over 9+ years of IT experience in teh field of Data/Business analysis, ETL Development, Data Modeling, Data Management & Data Governance.
• Strong experience in Business and Data Analysis including a solid understanding of Business Requirements Documents (BRD) and Functional Requirements Document (FRD), Data Profiling, Data ingestion, Data Migration, Data Integration, Data Governance, Data Conversion, Metadata Management, Master Data Management (MDM), Enterprise Data Warehouse(EDW) and Business Intelligence (BI) projects.
• Over years of experience in Data Modeling wif expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling, Normalized and De-Normalized models using Erwin and Embarcadero.
• Strong end-user computing skills (Excel, SharePoint, Power Point, Word).
• Extensive experience using data cleansing techniques, Excel pivot tables, formulas, and charts.
• Ability to collaborate wif peers in both, business, and technical areas, to deliver optimal business process solutions, in line wif corporate priorities.
• Proficientnoledge in statistics, mathematics, and analytics. Excellentunderstanding of business operations and analytics toolsfor TEMPeffective analyses of data.
• Worked extensively on Erwin and ER Studio in several projects in bothOLAP and OLTPapplications.
• Knowledge in Business Objects, Cognos, SAS, Tableau and OBIEE, QA automation.
• Worked extensively on Excel and experience wif utilizing VLookups sorting and filtering.
• Created and monitored workflows and tasks using Informatica PowerCenter Workflow Manager.
• Expertise in Master Data Management (MDM) concepts, Methodologies and ability to apply this noledge in building MDM solutions
• Strong experience in interacting wif stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Experience in Working wif Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) wif expertise in documenting various requirement specifications, functional specifications, Test Plans, Multi-table queries, Source to Target mappings, SQL Joins.
• Experience in coding PL/SQL, SQL using Procedures, Triggers and Packages.
• Good understanding of Relational Database (RDBMS) Design, Data Warehouse/OLAP concepts and methodologies.
• Worked on different platforms such as Windows 95/windows/98/NT and UNIX, Tableau, Sun Solaris, AIX, HP.
• Knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Experience in Working wif different industries like Healthcare, Broadcast, Telecom, private banking and noledge on wealth management, financial, retails.
• Implemented Optimization techniques for better performance on teh ETL side and also on teh database side.
• Experience in creating functional/technical specifications, data design documents based on teh requirements.
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS

Processes/Methodologies: Agile, Waterfall

ETL Tools: Informatica IDQ 9.1, Datastage11.3, Ab initio, SSIS

DATA Modeling: Erwin 7.1, ER Studio 9.1, Power Designer, Microsoft Visio 2003

Databases: Oracle 11g/10g/9i, MS SQL Server 2017/2016/2012/2008, MS Access, Teradata

Operating Systems: Windows, UNIX, Sun Solaris, AIX, HP

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting, XML

Reporting/Analysis: Business Objects 5.0, COGNOS 7.0 and Crystal Reports, Microsoft Power BI

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Data Analyst/ BI Developer

Responsibilities:

• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS).
• Integrated custom visuals based on business requirements using Power BI desktop.
• Provided continue maintenance and development of bug fixes for teh existing and new Power BI Reports.
• Gatheird and documented business requirements for analytical reports.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), to support Power BI and SSRS reports.
• Created drill down and drill through reports wif parameters in Power BI and SSRS.
• Developed custom calculated measures using DAX in Power BI to satisfy business needs.
• Developed multiple dashboards, analytical reports, KPIs, and interactive reports based on business requirements using Power BI and SSRS.
• Created tables, matrix, and chart reports as required and deploy those reports into Power BI Service.
• Implemented security measures at Power BI Service by implementing autantication and authorization methods.
• Performed teh Power BI report validation against teh databases.
• Deployed and scheduled teh reports in teh Power BI Service.
• Created workspace and content packs for business users to view teh reports.

Environment: MS SQL Server 2017, SSIS, SSRS, MS-Office, Visual Studio 2015, SQL, TSQL, Microsoft Teams, Microsoft Power BI.

Confidential, Los Angeles, CA

Sr. Data Analyst

Responsibilities:

• Defined and documented requirements for conversion and interface programs
• Prepared technical design documents including detailed data mapping documentation
• Developed conversion and interface programs based on approved specifications (Combination of SSIS, T/SQL, and SQL)
• Performed data analysis and developing data validation scripts to ensure teh quality and reliability of migrated data
• Developed teh SQL database scripts for fixing teh issues.
• Loaded data into target data tables in teh application schema
• Developed exception and data validation reports for transformation and load jobs
• Executed SQL scripts, TSQL (stored procedures) and ETL load processes
• Used Microsoft ETL/data integration tools, such as DTS/ SSIS to load teh data.
• Worked on bug fixes and enhancements.
• Maintain integrity, cleanliness, consistency and organization ofdatafrom various sources.
• Developed source to target mapping documents, including business transformation rules.
• Reviewed teh logical model wif application developers, ETL Team, DBAs and testing team to provide information about thedatamodel and business requirements.
• Define teh list codes and code conversions between teh source systems and Master Data Repository.
• Executed teh test cases to test teh functionality of teh software as per teh business rules.
• Interacted wif teh developers to resolve teh technical and implementing issues.

Environment: MS SQL Server 2016, SSIS, MS-Office, Visual Studio 2015, SQL, TSQL, TFS.

Confidential, Eden Prairie, MN

Sr. Data Analyst

Responsibilities:

• Reviewed technical documentation to verify client requirements
• Converted business data requirements into complex formatted data input spreadsheets
• Executed SQL scripts and ETL load processes
• Responsible for loading, extracting and validation of client data.
• Troubleshoot data movement errors and issues
• Evaluated data loads through database queries
• Extensively usedSQLstatements to query theOracle DatabaseforData ValidationandData Integration.
• Created T-SQLstored procedures, functions and packagesfor moving teh data from staging area to data mart.
• Performeddata analysisanddata profilingusing complexSQLon various sources systems including Oracle andMicrosoft SQL Server.
• Document, clarify and communicate requests for change requests wif teh requestor and coordinate wif teh development and SA team.
• Responsible for defining teh key identifiers for each mapping/interface.
• Review project deliverables for completeness, quality, and compliance wif established project standards
• Involved in defining teh source to target data mappings, business rules, business and data definitions.
• Identify, clarify and resolve project activity issues and risks, escalating them as needed
• Document and communicate teh status of progress against plans, taking corrective action as necessary
• Reviewed ongoing and new product changes to identify opportunities for process improvement

Environment: SQL/Server, Oracle10&11g, MS-Office, SSIS, Oracle Toad, PL/SQL, ALM, Excel, MS Visual Studio 2008.

Confidential, Denver, Colorado

Sr. Data Analyst

Responsibilities:

• Document teh complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Responsible for creating weekly and monthly reports for viewership data based on set top box.
• Involved in defining teh source to target data mappings, business rules, business and data definitions.
• Designed a STAR schema for teh detailed data marts and Plan data marts involving confirmed dimensions.
• Involved wif ingesting data received from various relational database providers for analysis and other big data operations.
• Involved in Building teh data mining data base: tasks like data collection, data selection, data cleaning and solving data quality problems.
• Performeddata analysisanddata profilingusing complexSQLon various sources systems including Oracle andTeradata.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL plus.
• Designed Data Quality using IDQ and developed several informatica mappings.
• Worked atconceptual/logical/physical data model level using Erwin according to requirements.
• Designed and developed several mappings to load data from Source systems to ODS and tan to Data Mart.
• Created teh conceptual model for teh data warehouse using EMBARCADERO ER Studio data modeling tool.
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Replicate operational table into staging tables, transform and load data into warehouse tables using Ab Initio GDE.
• Worked on some impact of low quality and/or missing data on teh performance of data warehouse client.

Environment: SQL/Server, MS-Office, Informatica(IDQ) 8.6.1, PL/SQL, Ab Initio GDE 1.14, Business Excel, Embarcadero, ER Studio, Netezza, XML, Teradata, Linux, MS Visio 2003

Confidential, Minnetonka, MN

Sr. Data Analyst

Responsibilities:

• Reviewed technical documentation to verify client requirements
• Converted business data requirements into complex formatted data input spreadsheets
• Executed SQL scripts and ETL load processes
• Responsible for loading, extracting and validation of client data.
• Troubleshoot data movement errors and issues
• Evaluated data loads through database queries
• Extensively usedSQLstatements to query theOracle DatabaseforData ValidationandData Integration.
• Created T-SQLstored procedures, functions and packagesfor moving teh data from staging area to data mart.
• Performeddata analysisanddata profilingusing complexSQLon various sources systems including Oracle andMicrosoft SQL Server.
• Document, clarify and communicate requests for change requests wif teh requestor and coordinate wif teh development and SA team.
• Responsible for defining teh key identifiers for each mapping/interface.
• Review project deliverables for completeness, quality, and compliance wif established project standards
• Involved in defining teh source to target data mappings, business rules, business and data definitions.
• Identify, clarify and resolve project activity issues and risks, escalating them as needed
• Document and communicate teh status of progress against plans, taking corrective action as necessary
• Reviewed ongoing and new product changes to identify opportunities for process improvement

Environment: SQL/Server, Oracle10&11g, MS-Office, SSIS, Oracle Toad, PL/SQL, ALM, Excel, MS Visual Studio 2008.

Confidential, Topeka, KS

Data Analyst

Responsibilities:

• Responsible for envisioning and implementing data governance and privacy regulating of teh Sprint Sales & Services Group
• Defined accountability procedures governing data access, processing, storage, retention, reporting and auditing measuring contract compliance
• Ensured that Business, Data Governance and Integration team leads are deeply involved in critical design issues and decisions
• Defined teh list codes and code conversions between teh source systems and MDR, MDM
• Implemented metadata standards, data governance and data stewardship, master data management(MDM), ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modelling
• Performed data analytics on teh existing data warehouse.
• Extensive Excel work using pivot tables and complex formulas to manipulate large data structures.
• Involved in defining teh business/transformation rules applied for ICP data.
• Worked wif project team representatives to ensure that logical and physical ER/Studio data models were developed in line wif corporate standards and guidelines.
• Supported ERP system users by providing troubleshooting, report generating, SQL query writing and system analysis services
• Developed teh financing reporting requirements by analyzing teh existing business objects reports.
• Interact wif computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Utilized Informatica toolset Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ) to analyze legacy data for data profiling.
• Responsible in maintaining teh Enterprise Metadata Library wif any changes or updates.
• Generated weekly and monthly asset inventory reports.
• Coordinate wif teh business users in providing appropriate, TEMPeffective and efficient way to design teh new reporting needs based on teh user wif teh existing functionality.

Environment: SQL/Server, Oracle 9i, PL/SQL, MS-Office, Ab Initio, Erwin 7.1, Informatica IDQ 9.1.0, Teradata, Excel, ER Studio, Linux.

Confidential, Cincinnati, OH

Data Analyst

Responsibilities:

• Worked according to teh software development life cycle(SDLC).
• Gatheird requirements from remotely based business users and defined and elaborated teh requirements by holding meetings wif teh users (who are also Fifth-third employees).
• Analyzed teh historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote teh business requirements document and got it electronically signed off from teh stake holder.
• Enforced referential integrity in teh OLTP data model for consistent relationship between tables and efficient database design
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs wif teh stakeholders.
• Worked atconceptual/logical/physical data model level using Erwin according to requirements
• Interacted wif teams in AFS, ACBS and infolease to extract teh information for teh reports.
• Created Report-Models for ad-hoc reporting and analysis.
• Created Logical/physical Data Model in ERwin and has worked on loading teh tables in teh Data Warehouse.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Provide 24 x 7 problem management supports to teh development team.
• Document various Data Quality mapping document.
• Worked on daily basis wif teh main frame team and lead data warehouse developers to evaluate impact on current implementation.
• Upgraded teh present application by adding new functionalities and adding new reports.
• Wrote regression test cases, did smoke testing wif users.
• Coordinated (wif business users, data base administrator, mainframe team and testing team) in mirror to production testing.
• Conducted User Acceptance testing (UAT) and worked wif users and vendor who build teh system.

Environment: MS Office 2007, MS Visio 2003, PL/SQL, SQL Loader, Windows XP, AFS, MS Excel, PowerPoint, UML, Erwin 7.1, SQL Server, Erwin, Crystal Reports, MS Outlook.

Confidential

Business Analyst

Responsibilities:

• Involved in PolicyCenter customization wif BA/SME's and in validating according to teh Auto Business process of American Family Insurance.
• Teh major business jobs of a PolicyCenter is storing information about a policy and managing a set of processes.
• If completed successfully these jobs might trigger an action in other products like Claims Center, BillingCenter and Contact Management System wif other applications/products like On Base. Reviewed and analysed functional requirements, system requirements and business requirements.
• Responsible for teh collection of functional requirements, non-functional requirements, data mapping, and light data modeling.
• Database table review and data mapping for large scale data conversion project Oracle database to Mainframe.
• Involved in designing and maintaining testing process documentation, strategies and plans. Communicated wif BA/SME's and turned project requirements and Business Process Flows into apt user stories.
• Created Test Cases for user interface, functionality and system using user stories based on product backlog. Actively participated in daily scrum meetings, sprint backlog planning and in evaluating user stories in points.
• Involved and participated in introspective sprint review meetings wif other agile team members. Involved in estimating burned down chart for measuring teh progress of teh project wif stakeholders.
• Queried database using SQL queries to ensure data integrity and to validate teh inserted and updated data.
• Involved in creating teh frame work for automation testing. Executed test scripts in QTP for regression testing to ensure teh quality of teh system.
• Maintained RTM to check if all teh requirements are implemented and Tested according to entry/exitcriteria.

Environment: Microsoft Office, Oracle 9i (SQL), and Manual Testing, Guidewire Application suite.