SUMMARY:

• Experienced consultant with a solid data warehousing, business intelligence, and analytics experience
• Consultant with extensive knowledge of SQL and Excel for validating and identifying data inconsistencies
• Business analyst with solid experience of requirements gathering and data analysis
• Experience of root cause analysis (Pareto method, SPC, Fish - bone) to recommend process improvements
• Experience building Tableau reports, dashboards, and stories to enable management decision making
• Five years of experience defining key performance indicators (KPIs) and metrics; experience benchmarking complex government processes and or metrics
• Conducted key strategic analyses requiring application of business intelligence and/or data mining software and employing large datasets to produce actionable recommendations
• Responsible for participating in requirements gathering process for data integration, data analytics and information delivery solutions
• End user experience with traditional and emerging Informational Delivery tools such as Microstrategy, and Tableau
• Extensive experience creating metadata and data dictionary
• Hands-on experience with ETL tool such Informatica
• Developed complex SQL using advanced SQL functions (RANK, PIVOT) in an RDBMS (Oracle, SQL Server, Access)
• Hands on experience summarizing, transforming, segmenting, joining datasets
• Intermediate Level MS Excel expertise including pivot tables, look up functions, basic VBA, Monte Carlo Simulations
• Intermediate Level R analytics expertise (Linear Regression, Logistic Regression); Preparing for Tableau certification
• Entrepreneurial spirit with the ability and willingness to engage in many different and simultaneous tasks
• Desire to learn and mentor others via hands-on, apprenticeship model
• Experience of handling small to medium sized projects; Demonstrated understanding of SDLC
• Understands the concepts of project management according to PMBOK and Project Management Lifecycle
• Data warehousing experience in different domains such as Medicare, Health insurance, Finance and Telecom
• Effective interpersonal skills to interact professionally with a diverse group, including executives, managers, and subject matter experts

TECHNICAL SKILLS:

Reporting Tools: Tableau 9, Microstrategy Reporting Suite 9, MS-Excel

Database (RDBMS) / SQL: Oracle (10g/9i), SQL Server (2005/08), DB2, MS Access

ETL Technology: Informatica PC 8.1/8.6/9

Platforms (OS): Windows 8.1/7, Vista, XP; Mac OS X, Unix(ksh)

Languages: R, SQL, SAS procs, Excel VBA Marco, C, PL/SQL

QA/Validation tools: HP Quality Center/ALM, TOAD, Selenium, JAWS

Process/Data Modeling Tool: OmniGraffle, Visio, Erwin 3.5

Automation: Rational Test Director, Selenium, JAWS, Confidential

Standards & Frameworks: CMMi Level 5, BS7799 (European Software Standard)

Management tools: Quality tools and techniques (Pareto Analysis, SPC control charts, Histogram), Measures and metrics, Reviews, Audits and assessments

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Business Data Analyst

Responsibilities:

• Analyzed Data in the Confidential for validation and error detection using technologies like SQL, and techniques like Visualization and tools like Excel, R and Tableau
• Identified Fraud and Waste scenarios by extracting data from Relational databases using advanced SQL skills and strong understanding of relational and dimensional data models
• Developed reporting and metrics to understand overall business unit performance
• Translated analytic data/insights into actionable recommendations by utilizing visualization tools
• Collaborated with stakeholders to develop a deep understanding of business methodologies, and KPIs
• Applied methods like association rule/clustering analysis, Regression analysis for recommending scenarios
• Communicated analyzed information in a clear manner to enable decision-making by leadership
• Utilized Business Intelligence applications to develop executive dashboards and operational scorecards
• Developed prototype Reports and Visualizations with Tableau Desktop
• Conducted and facilitated sessions to develop and coordinate the requirements, specifications, design, and testing efforts for medium to large projects
• Conducted key strategic analyses requiring application of business intelligence software and employing large datasets to produce actionable recommendations
• Updated existing BRDs and created new BRDs as required from required gathered from business users
• Contributed to preparing data dictionary for Association data sources, and defining the metadata
• Defined and developed UAT strategy to support Data validation and User Acceptance Testing
• Extensively used data models to expose hidden (non-obvious) relationships for UAT validation
• Recommended promotion of software to production based on satisfactory test results
• Conducted presentations to effectively communicate clear and concise recommendations
• Oversaw day-to-day implementation and analysis of the different initiatives
• Served as a liaison between the business community (end users) and the technical team
• Planned and managed the User Acceptance testing phase including the preparation of high level test plans, use cases and test scripts
• Created and managed core project documentation such as project plans, issue logs, and risk logs
• Deliverable compliance with Health Insurance Portability and Accountability Act (HIPAA) regulations
• Identified ways to improve and enhanced MicroStrategy reports, increasing BI value and usability
• Performed document management and content management using SharePoint

Environment: Windows-7, Oracle 11g, Tableau, R Studio, UNIX, TOAD, XML, MS Excel, Erwin, IBM ClearQuest, Share Point

Confidential, Baltimore, MD

Business Analyst- BI & Analytics

Responsibilities:

• Received program Award for contributions to the successful release of ACA reports (Obamacare)
• Converted business specifications for Reports into Microstrategy solutions through effective design, development and unit-testing to enable managing systems related to quality, cycle time, and productivity
• Conducted requirements gathering to define metadata and capture reporting/data requirements
• Researched Fact, Aggregate and Dimension tables to provide data and visualization solutions
• Performed process modeling using story board technique and flow charts to lay the process for data acquisition, and ad-hoc reporting using free form SQL
• Contributed to the successful proof-of-concept of Tableau visualizations for data analysis purpose
• Developed prototype Reports and Visualizations with Tableau Desktop
• Applied advanced Oracle functions such as Regression and Regular Expression for business data analysis
• Performed validation of Microstrategy objects using JAWS for government regulatory compliance (508)
• Analyzed data and provided visual prototypes for transition of Microstrategy Reports to compelling Tableau Visualizations
• Prepared and executed UAT test cases that included validation of metadata
• Validated different types of Microstrategy objects such as Grid reports, Dashboards, and Heat maps
• Conducted User Acceptance testing of the reports by means of high level test plans, cases and test scripts
• Worked with data modelers to comprehend data model to join tables and expose redundancies
• Peer reviewed test cases and SQL queries for critical Functional releases including ACA release
• Conducted gap analysis to identify root causes and assist with problem management
• Created analytical tools necessary to support Operational analysis

Environment: MicroStrategy 9, Tableau8, Informatica 9 (Power Center, metadata manager), Oracle 10g, Windows-7, UNIX (ksh), MS Excel, Erwin, JAWS, TOAD, XML

Confidential, McLean, VA

Report Data Analyst

Responsibilities:

• Worked with stakeholders to understand business objectives, define key performance indicators (KPI) based on those objectives, and provide relevant data, including analysis and insights
• Performed requirements gathering specific to ad-hoc requests, compliance, reports and data scenarios
• Developed prototype Microstrategy reports, dashboards for reporting and visualization
• Provided executive-level summaries of data through impactful visual designs of historical trending of data
• Explored Loan Level Disclosures file using SAS procs for quicker identification of hidden data relationships
• Created Validation queries(SQL) for data testing of Microstrategy Reports to ensure accuracy of reporting
• Created Complex SQL Queries employing analytic functions DENSE RANK, LEAD, LAG, and ROW NUMBER
• Created functions in R to run over Loan Performance datasets (Single Family) for monthly audit
• Performed UAT of reports across categories like Functionality, Security, Data and Cosmetic testing
• Used Atlassian suite (JIRA) for defect life cycle management of all reports
• Created Fit gap analysis report of the existing compliance architecture and modules
• Worked with the business community to resolve various processes and technical issues
• Participated in white-boarding the roadmap for data acquisition for Reconciliation Reports
• Provided accurate effort estimation by categorizing reports as operational and strategic on the basis of user profile and frequency of use and preparation time
• Reduced turnaround time by preparing separate templates for strategic and operational reports
• Performed data comparison of multiple Loan Level Disclosure files using SQL queries in MS Access 2007
• Compared the Loan Level Disclosure file against the Credit Supplement file published quarterly by Confidential to highlight data quality for investors
• Ensure compliance and establish data governance standards and guidelines across different business units with the Enterprise Data Governance team.
• Provided relevant data and SQL queries to the disclosure team to generate reports for Compliance, Audit, and Monitoring of data

Environment: Oracle 10g (SQL), SAS, R, MicroStrategy Reporting suite, MS Excel, MS Access, JIRA

Confidential

DW QA Analyst

Responsibilities:

• Validated different types of SSRS report objects such as Grid reports, and information rich Dashboards
• Reviewed Informatica mappings and workflows to verify implementation of data transformations
• Analyzed data (metric and attributes) in fact tables and dimension table to resolve data issues
• Performed cosmetic testing, Functionality testing, security testing, Data testing of reports
• Experience working with high volume database systems
• Gathered and documented users requirements specific to performing business data scenario validation
• Cross functional experience in a SCRUM/Agile setup with milestones, weekly sprints, and Daily stand-ups
• Worked on usage data for obtaining trends and for predictive analysis (e.g. Regression, churn)
• Created Validation queries(SQL) for data testing of SSRS Reports to ensure accuracy of reporting
• Validated dimensional data model to remove inefficiencies, and redundancies
• Created Validation queries (SQL) for testing of ETL workflows using ETL mapping document
• Prepared DDL and DML scripts for the purpose of SSRS reports and ETL testing
• Conducted different types of testing for ETL workflows such as smoke testing and functional testing
• Managed ticket and defect life cycle with HP Quality Center
• Performed data profiling for all new data acquisition projects, and for providing profile to customers
• Peer reviewed test cases and SQL queries for critical Functional releases
• Utilized technologies such as SQL to ensure zero data loss in each iteration of Agile Testing
• Ensured accuracy of data by defining and building necessary controls (standardized test cases)
• Verified database tables by using functions (Minus, Union all, etc.) available in SQL
• Created Validation queries (SQL) for testing of ETL workflows using ETL mapping document

Environment: Informatica Power Center 8.1, MS SQL Server, Windows XP, Unix, HP Quality center

Confidential

Programmer Analyst

Responsibilities:

• Presented with a department Star Award for quickly and effectively training a new team of 20+ engineers to test a complex data system for regulatory compliance purpose
• Improved requirements gathering by implementing engaging methods of communication with customers and by handling requirements specification using tools
• Analyzed source data to streamline data flow into Confidential from government and industry sources
• Prepared data dictionary explaining new data from newer diverse data sources
• Planned weekly sprints required for testing in consultation with the BA, developer and the Customer
• Developed scenarios for SIT testing with business viewpoint (such as presence of natural keys)
• Prepared Test cases for technical testing such as shell script, input files, Abends, SCD type I, II)
• Created Complex SQL Queries employing analytic functions including Rank, Lead, Lag, Minus, Union all
• Performed cosmetic testing, Functionality testing, security testing, Data testing of reports
• Fulfilled data requests from internal customers, external customers and regulatory entities (Ofcom)
• Conducted Hand-off meetings to hand over the release/ticket for production movement
• Managed trouble tickets and defect life cycle with HP Quality Center
• Experience working with high volume database systems
• Prepared test documents such as Test strategy and Master Test Plan

Environment: HP Quality center, SQL Developer/Toad, Putty, Informatica, MicroStrategy, Rational Doors

Confidential

Programmer Analyst / Project Lead

Responsibilities:

• Received departmental award for personal contributions in the successful service launch in a multi-vendor environment; coordinate tasks with vendor teams in Austria, England, India, and Northern Ireland
• Collaborated with a cross-functional team of delivery managers, product line representatives, IT teams, and vendor liaison for status and information flow leading to timely roll out of service
• Identified and mapped test cases to functionality in Requirements Traceability Matrix (RTM)
• Analyzed data (metric and attributes) in fact tables and dimension table to resolve data quality issue
• Created advanced SQL Validation queries for validation of Fact and Dimension table incremental load
• Reviewed and tested data definition language DDL and DML scripts prepared by the design and ETL teams
• Conducted different types of testing for ETL workflows such as smoke testing and functional testing
• Entrusted with planning data migration activities and turnover to User Acceptance Test Team
• Created data porting use cases to model scenarios where customers from different carrier’s port in
• Real time database testing (using text messages) of the Mobile-World online platform
• Contributed to environment set up, artifacts review, and test strategy preparation

Environment: Informatica PC, PeopleSoft (CRM), Oracle 9i, HP Quality Center, SVN, SQL Developer

Confidential

Software Engineer

Responsibilities:

• Assisted the Project Manager in preparing Project Plan, work estimation template and Test plan
• Carried out activities such as planning and scheduling, tracking work and progress reporting
• Mitigated the number of defects by promoting the use of defect resolution meetings
• Charged with implementing BS7799 standards and preparing the department for the subsequent audit
• Improved project efficiency by implementing international standards including CMM
• Augmented business domain awareness in the business unit through the use of a palette of communication strategies including e-mails, bulletin board messages, and newsletters
• Selected as one of 11 out of 30 team leads to provide 360-degree feedback for senior managers
• Achieved CMM Level 4, by adopting Statistical Process Control (SPC) charts to supervise projects in addition to defects prevention (DP) and knowledge management(KM) activities

Environment: Mainframe, JCL, CICS, MVS, DB2, and Confidential (automation), Endevor, TFS

Confidential

Software Engineer

Responsibilities:

• Participated in joint application design (JAD) sessions to analyze requirements for Rating Engine module
• Wrote software routines to implement electronic data interchange to check credit history of customers
• Created over 300 Confidential test scripts for Automation testing in legacy environment(mainframe)
• Performed Backend Testing of the application’s DB2 database
• Conducted Regression testing using Confidential before each monthly release
• Contributed to domain awareness in a department comprising over 400 engineers and managers
• Became key point of contact (poc) for eTOM model and other knowledge management (KM) activities
• Created JCL Scripts to update DB2 database by batch processing method;
• Contributed to achieving CMM Level 3, by practicing configuration management, defects prevention
• Became key point of contact for defects prevention (DP) activities
• Designed an innovative and workable release management process comprising checklists and KPI, significantly reducing the number of bugs caused by improper configuration
• Achieved departmental goal of reducing overall Defects Injection Rate (D.I.R) and Cost of Quality (C.o.Q)

Environment: Mainframe, JCL, CICS, MVS, DB2, and Confidential (automation), Endevor