SUMMARY

• Over 8+ years of diversified experience in all phases of the Software Development Life Cycle (SDLC). Have worked with requirements elicitation and analysis, database design and development, data analysis, application development, testing, implementation, and support.
• Experience in Analyzing user needs and software requirements to determine feasibility of design within time and cost constraints.
• Strong experience in Requirement Gathering, Gap Analysis, Business Process Modeling, Data Quality Analysis, Data Conversions, Source Systems Analysis and Reporting Analysis.
• Superior is writing SQL using all major RDBMS, very strong in performance tuning and query optimization also good in using advance analytical SQL capability.
• Over 3 years of experience in development and implementation of Business Intelligence applications using Cognos BI and multi - tiered Client/Server applications with Internet/Intranet application development experience
• Worked with all components of Cognos BI including Cognos Connection, Framework Manager, Report Studio, Analysis Studio, Workspace, Workspace Advance, Event studio, and Query Studio
• 3+ years of experience on SQL Server 2012 or advanced versions.
• Proficient at data visualization using Power BI and a strong application development.
• Expert in using advanced calculations using MS Power BI Desktop (Aggregate, Date, Logical, String, Table)
• Good at creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI or Tableau.
• Developed ETL specification document to integrate source system to identify the source and target mappings.
• Created ETL technical design documents like Source to Target mapping with complex transformation logic.
• Flexible to work with any Data Warehousing Tools (ETL) like DataStage or Informatica.
• Good experience on interfaces, Data Migration, Data Analysis and Data Conversion.
• Experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables) using OLTP and OLAP.
• Requirements gathering from all functional leaders, understanding and consolidating it to make a System Requirement Specification document (SRS).
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Develop data models according to company standards.
• Maintain conceptual, logical and physical data models along with corresponding metadata/Data Dictionary.
• Experience in facilitating Joint Requirement Planning (JRP), JAD (Joint Application Development) sessions and requirement elicitation sessions with Business Users Groups, SME’s, and IT Groups to converge early towards a design, acceptable to the customers and feasible for developers to limit a project’s exposure to the forces of change.
• Domain Experience: Banking, Insurance, Finance and Manufacturing (MES)
• Effective written, oral, and interpersonal skills to present ideas to teammates and non-technical individuals
• Performed POC on Tableau report development using HDFS/Hive Tables in Cloudera Hadoop platform.
• Good Knowledge on Snowflake cloud database, Azure and AWS.

TECHNICAL SKILLS

Business/System Analysis: Requirement analysis, business rules, data flow diagram, flowcharts, business process modeling & improvement, Use Cases, Test Case, Test Scripts, gap analysis, cause and effect analysis, ER Diagrams, decision tree, BRD, BRS, JADS sessions.

Methodologies: SDLC, Waterfall model, Agile, UML.

Process model tools/ software packages: MS Office tools (MS Word, MS Excel), MS Project, MS Visio, DOORS, SDLC, Microsoft office Outlook 2003/2007, IBM Lotus Notes, SDLC.

Testing Tools: HP Quality Center

Version Control: SVN, ClearCase, BitBucket

Databases: Oracle 11g/10g/9i, MySQL, PostgreSQL, MS SQL Server /2018, MS Access, Snowflake cloud database

Languages: SQL, t-SQL, PLSQL

Relevant Skills: Project Management, Product Manager, design, strong problem solving and analytic skills

Operating Systems: Windows (95/98/2000/ 2003 Server/XP/Vista,7), Linux, Unix

ETL Tools: Talend Big data Enterprise Edition, IBM Datastage, IBM Data Manger

Data Modeling Tools: SAP Power Designer, Oracle Data Modeler, CA Eriwin

Reporting Tools: Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, Tableau 10, Datameer,MS SQL Reporting Services, Cognos 11/10/8.4/8.3 Report Studio, workspace Advance, Active Reports, Cognos Query/Analysis Studio, Crystal Reports

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Senior Data Analyst

Responsibilities:

• As a Senior Data Analyst, define, drive, and manage requirements for the project
• Define scope and write project charter to communicate high level requirements
• Prepare Business Requirement Documents (BRD), Requirement Traceability Matrix (RTM)
• Conduct requirements gathering meetings with the stakeholders.
• Conduct JAR (Joint Application Requirement) sessions between the technical & business team to gather and confirm project requirements.
• Define the data flow diagrams using Microsoft Visio.
• Extensive experience in working closely with End-Users, Business Users, End-Clients for gathering User and Business Requirements and authoring business processes and documents with project teams.
• Complex data mapping skills from one source system to another.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Maintain conceptual, logical and physical data models along with corresponding metadata/Data Dictionary. created multiple dashboards, volume reports, operating summaries, and presentations and graphs also performed SSRS Integration with Power BI.
• Involved setting up Data Gateway for data refreshing, content Pack Library.
• Worded on publishing reports to app.powerbi.com and setting up the necessary connection details and scheduling.
• Experience in creating Business Requirement Documents (BRD), Use Case Specifications, Functional Specifications, Requirements Traceability Matrix (RTM) to meet the project deliverables.
• Follow the Agile methodology. Attend stand-up meetings, analyze requirements, and estimate effort.

Environment: Power BI Desktop, Power BI Service, Power BI Gateway, Power BI Report Server, SQL Server 2014, MySQL, Advance Excel, SQL, TSQL, Erwin 9.3,JIRA, Rally

Confidential, Dallas, TX

Senior Data Analyst

Responsibilities:

• Recommend and design system to align with organizational strategic business objectives.
• Evaluate business requirements, analyze existing reporting system, review current and future state process flows and perform gap analysis
• Provide input to the development team, testers, and project architects
• Developed the Production Handoff and related documents and handled post-deployment related activities, providing 24x7 monitoring and support. Worked closely with the stakeholders to resolve issues; identified and fixed bugs and issues in production.
• Provided data analysis support to the Informatica ETL, and business teams.
• Led meetings to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance. Utilized Star Schema and ERwin for data modeling.
• Developed SQL scripts for Oracle databases.
• Created Conceptual, Logical and Physical Data Models.
• Created Data Mapping between the source and target systems including the business/Transformation rules.
• Establish and monitor the processes for defect management, change management, and quality management.
• Working with the business users to understand the structure of the data, business logic and rules to be applied and propose technical solutions to meet the business needs.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Participated in building and visualizing dashboards using Tableau Desktop.
• Used Tableau to generate Tableau combination dashboards and wrote SQL Queries for testing the tableau report/dashboard.
• Worked as a liaison between the business users and the systems developers, Testers.
• Provided and support to ensure a smooth transition to the new environment.

Environment: Tableau 9.0, SQL Server 2012, PostgreSQL 8.3, Control M, Excel, Putty

Confidential, Coppell, TX

Senior Data Analyst

Responsibilities:

• Understanding the system/business requirements and worked closely with BA, SSAS team for Cognos cube creation
• Developed financial/business reports for different departments for better handing the mortgage products
• Developed dashboards in Cognos Report Studio using charts, crosstabs, and for interactivity used html/Java script
• Added filters in Cognos Layout Component for better control, portability and standardization
• Worked closely with SSAS team and helped team members in understanding and completing tasks in time
• Tested authenticity of report’s data using SSAS cube browser, SQL queries, and actual data extracts
• Created detailed reports for drill through and linked them with crosstab and chart reports
• Used Bar, Line, Bullet, Gauge, Area, and Combination charts along with Map to slice data for selected state
• Tested the reports for PDF, word, excel formats and do modifications to get full un-truncated data
• Created Cognos packages using Relational/Dimensional data and used them for summary and detailed reports
• Crosstab/Graphical reports developed for analysis and List reports developed for detailed information
• Enabled Drill-Up and Drill-Down for different hierarchies in crosstab and chart reports
• Added individual users and groups in different folders and permit them according to their role and need
• Developed trending reports for showing the variance between different time periods
• Created mockups, templates, and mapping documents for standardized report development and created help document for better understanding of report flow and levels

Environment: Cognos 10.2, FW Manager, Report/Analysis/Workspace Studio, SSMS, SSAS, SQL, JavaScript

Confidential, Columbus, IN

Senior Data Analyst

Responsibilities:

• Prepare Project Charter & Project Plan.
• Understand existing business functionality & prepare the requirement documents.
• Review the functional design document with the application team and act as a domain SME during the technical design
• Create UAT plan and act as a liaison between business and application team for UAT
• Create and circulate issue log to stakeholders. Manage and track until the closure of the issues.
• Created Conceptual, Logical and Physical Data Models.
• Created Data Mapping between the source and target systems including the business/Transformation rules.
• Involve in creating different database objects for the current Modules like NSPT (Non Serialized Part Tracking), Assembly and Machining.
• Project Plan creation and executing the modules as per the timelines, keep on monitoring the specific tasks as per the deadlines.
• Involved in testing & deployment activities.

Environment: ORACLE 10g, SQL Server 2008, MySQL, Tableau 8.1, Excel, WinScp, JIRA, Icescrum

Confidential

Senior Data Analyst

Responsibilities:

• Prepared Functional and Technical Design Documents like LLD, HLD, and FDD.
• Involved in Development & Review of DataStage Parallel Jobs.
• Coordinated with client managers, business architects and data architects for various sign offs on data models, ETL design docs, testing docs, migrations and end user review specs.
• Created Conceptual, Logical and Physical Data Models.
• Created Data Mapping between the source and target systems including the business/Transformation rules.
• Involved in data modelling activities for ADP Payroll project.
• Involved in creating different data base objects like Tables, Functions, Sequence and Views.
• Involved in creating DB Scripts for all modules.
• Prepared the status reports on daily basis & participated more on client meetings.

Environment: DataStage 8.0, ORACLE 10g, SQL Loader, SQL Developer, Advance Excel, Unix, SQL

Confidential

Data Analyst

Responsibilities:

• Create different database objects like Tables, Functions, Sequence and Procedures
• Create Different Packages like DLE, DME & DGE.
• Created Conceptual, Logical and Physical Data Models.
• Created Data Mapping between the source and target systems including the business/Transformation rules.
• Understand business functionality & Analysis of business requirements.
• Resolve client issues spontaneously without any delays.
• Preparation of SLA reports.

Environment: ORACLE 9i, Erwin 7.3 PL/SQL Developer, Advance Excel