SUMMARY

• More than 8 years of experience Data Analysis, Data Profiling, Data Mapping, Data Migration, Data Conversion, Data Quality, DataGovernance, DataIntegration, Metadata Management Services, and Configuration Management.
• Proven technical expertise and business insight necessary to translate business requirements and objectives into scalable, highly resilient and successful system solutions.
• Familiar with all phases of Software Development Life Cycle involving requirement analysis, system design, implementation and testing; following Agile methodology.
• Facilitated and participated in Joint Application Development (JAD) and Joint Resource Planning (JRP) sessions with management, SMEs, vendors, users and other stakeholders.
• Experience in Business Objects modules like Information Design Tool, Designer, Business Objects Reporter, Web Intelligence Reporting (CMC, CMS, Desk I), Xcelsius to build dashboards & scorecards and provide the users with unique business information.
• Experience querying and interrogating data using complex SQL on DB2 or Oracle platforms using tools such as TOAD and other SQL query tools and using MS Access.
• Proficient in writing complex SQL queries, stored procedures, normalization, database design, creating indexes, functions, triggers, and sub - queries.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
• Experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like Tables, Constraints, & Indexes.
• Experience in implementation ofdatawarehousing solutions involving Dimensional modeling and Snow flake Schema implementation (3 NF).
• Worked on forward and reverse engineering processes and created DDL scripts to implement datamodeling changes.
• Good experience and knowledge in provisioning virtual clusters under AWS cloud which includes services like EC2, S3, and EMR.
• Adept and deep understanding of Statistical modeling, Multivariate Analysis, model testing, problem analysis, model comparison and validation.
• Expertise in MS Office tools including MS Excel, MS Access, MS Word, MS PowerPoint, & MS Project fordatamigration, reporting, and integration.

TECHNICAL SKILLS

Programming Languages: C, C++, C#, VC++, VB, SQL, PLSQL

Operating Systems: UNIX, Windows, Linux.

Databases: MS-Access, MySQL, SQL Server, Oracle

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCaseBug Tracking Tools Mercury Test Director, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Testing Tools: Quick Test Pro (QTP), Test Director, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Sr. Data Analyst

Responsibilities:

• Gathered Requirements and interacted with Subject Matter Experts to identify, understand and document business needs for data.
• Automate and enhance daily administrative tasks including space management, object alteration, database backup and recovery.
• Resolved the revolving issues by conducting and participating in JAD sessions with the Business and developers.
• Developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML and Business Process Modeling.
• Created Ad hoc reports for testing and supporting UAT and presented in as Excel spreadsheets forDataverification andDatavalidation.
• Developed SQL-based data warehouse environments and created multiple custom database applications for data archiving, analysis, and reporting purposes.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Executed ETL operations for Business Intelligence reporting solutions using Excel.
• Used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Worked with the database designer in data modeling through ER diagrams to identify tables, attributes and relationships between tables.
• Wrote DDL and DML statements for creating, altering tables and converting characters into numeric values.
• Worked with cross functional team to generate backlogs, capture them in JIRA, and work against the committed backlog against the sprint delivery schedule.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Integrated Crystal Reports using Erwin Data modeler.
• Created a process that would alert the team when errors occurred so no one had to spend time monitoring for errors or interruptions in processing.
• DevelopedTableauvisualizations, dashboards, stories and forecasted the data using Trend lines inTableau Desktop.
• CreatedTableauDashboards with interactive views, trends and drill downs along with user level security.
• Helped Data Scientists doing some Regressions and Classifications using Python libraries like Scikit-learn.
• Developed database objects such as Stored Procedures, User Defined Functions, Tables, Triggers, and Indexes using SQL Analyzer and Enterprise Manager.
• Documented the Requirement traceability matrix (RTM) and created Flow Diagrams using MS Visio.

Confidential, Worcester, MA

Data Analyst/Modeler

Responsibilities:

• Responsible for documenting all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Prepared Logical Data Models using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Used Erwin design tool & Erwin model manager to create and maintain the versions of the Inland Marine data model. Created integrity rules and defaults.
• Involved analysis of a variety of source system data, coordination with SMEs, development of standardized business names and definitions, construction of a non-relational data model using Erwin modeling tool.
• Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
• Worked in Data Analysis, data profiling and data governance identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Responsible for analysis & profiling source systems data for integration with data warehouse that includes data flow diagrams, source to target mappings & transformations using SQL.
• Used MySQL as backend database and MySQL DB of python as database connector to interact with MySQL server.
• Prepared logical and physical data models by recognizing the proper entity and the attributes and implementing a proper relationship between them.
• Involved in writing the SQL codes and utilizing analytical, aggregate functions.
• Writing complex SQL to redefine business requirement from different data sources.
• Responsible for defining the key identifiers for each mapping/interface.
• Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• Worked in Relational Database Concepts, Entity Relation Diagrams, Normalization and De-Normalization Concepts.
• Participated in weekly review meetings to report the documented test metrics and defects found in the System. Closed bug reports once they are resolved and verified.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from sources.
• Responsible for performing the data validation, process flow, dependency, Functionality Testing and User Acceptance Testing.
• Gather requirements and design of data warehouse and data mart entities.

Confidential, Dallas, TX

Business Data Analyst

Responsibilities:

• Gathered Business requirements by organizing and managing meetings with business stake holders, development teams and analysts on a scheduled basis.
• Analyze Different Data Sources like SQL Server, Oracle and Flat files from which has student information, college information, parent/sponsor information, loan contract, etc.
• Normalized the incoming files of different sources to 3NF at the staging area before loading into facts and dimension tables.
• Performed Data Profiling to assess the risk involved in integrating data for new applications, including the challenges of joins and to track data quality.
• Experience developing data transformation & cleansing rules for migration using ETL tools
• Analyzed multiple source system to identify the data for migration
• Coordinated data migration from old to new system during Teradata system capacity expansion.
• Performed data mining on data using very complex SQL queries and discovered pattern.
• Created DML code and statements for underlying & impacting databases.
• Solid Back End Testing experience by writing and executing T-SQL Queries.
• Worked with ETL team who ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Good experience in Data Extraction, Modification, Validation, Analysis, Management and Reporting using SAS Software.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.

Confidential, Marietta, GA

Business Objects/Crystal Report Developer

Responsibilities:

• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Developed universe and modified existing universe on SAP BW.
• Developed Universe and created classes, objects, Cardinalities, Contexts, Joins, External Strategies and Aliases for resolving loops and checked the Integrity of the Universes
• Created reports on WebI and DeskI using Business Objects functionalities like queries, Slice & Dice, Drill Down, @Functions, Cross Tab, Master/Detail and Formulas.
• Designed and developed Test Scenarios, Test procedures, Test Cases, and Test Data according to requirements.
• Extensively used Variables, Drill down, Slice and Dice in the creation of reports.
• Designed and Developed Dashboard using Crystal Xcelsius (with Dynamic
• Connectivity QAAWS).
• Installed Crystal Xcelsius designer and created Dashboards using Live Office with Data sources as WebI reports, Crystal reports, and flat files.
• Managed Crystal Enterprise repository with automatic versioning and scheduled reports accordingly with the data updates
• Used Query Panel in WEBI and DESKI to create reports applying Filters, Pre-defined Conditions, Alerters, Ranking, Sorting, prompts, charts and calculations.
• Imported - Exported reports from Multiple Data providers and User settings, created Formulae and Variables.
• Created reports using various layouts like Structure Layout and Page layout and hands on experience creating Drill-down reports.
• Created customized Web Intelligence reports as a source data for Live Office to
• Integrate Xcelsius on Corporate dashboards.
• Converted DeskI Reports to Web Intelligence using Report Conversion Tool.

Confidential, Deerfield, IL

Business Objects Developer

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications to generate the Reports.
• Interpreted business requirements and created System Requirement Specifications.
• Created universes, classes, objects, complex measure objects, prompts, pre-defined conditions.
• Worked on resolving loops, traps in Universes by creating alias tables and context joins.
• Resolved loops by either creating aliases or contexts or by defining shortcut Joins.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Used Import Wizard to migrate universes from Business Objects 6.5 to Business Objects XI R3
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Developed Xcelsius dashboards for presentations, live data dashboards with alerts, Calculators, Historical data comparisons.
• Created Excel-based interactive visual analytics, dynamic charts and groups and business presentations with Crystal Xcelsius.
• Created Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Created billing reports, charts using Universes as the main data provider.
• Created graphical representation of reports such as Bar chart, Pie chart as per the end user requirements.
• Created number of formulae, conditional display of fields for complex calculations and used them in different sub reports.
• Built queries to retrieve data in Oracle through a universe and set up query conditions.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.