SUMMARY

• Experience in application software analysis, design, development, implementation, maintenance, and documentation of commercial applications throughout various phases of project life cycle.
• Experience & knowledge of BI Tools like Power BI, Tableau.
• Interacting with Business users, gathering and analyzing requirements.
• Experienced in developing conceptual, logical and physical data models for OLTP and OLAP systems.
• Proficient in Oracle Data base design with relational models and very good experience in entity and attribute identification and developing the Entity - Relationships.
• Experience in data transformation, data mapping from source to target database schemas, data cleansing procedures.
• Well-versed in designing Star and Snowflake Database schemas pertaining to relational and dimensional data modeling
• Enforcing security by creating roles, granting system and object privileges on the tables, stored procedures.
• Provided support & maintenance of Power BI reports to business users.
• Knowledge of database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Good in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Participated in designing and development of software using agile development practices.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Experience working on creating models for Teradata master data management.
• Actively involved in capacity planning, creating views, materialized views, partitioning tables and creating indexes etc for optimization process.
• Created basic SSIS packages using excel or text files as source and Insert/Update records into SQL Server table.
• Have in-depth knowledge in Data analysis, Data warehousing and ETL techniques, Business Objects, UNIX Shell Scripting, SQL, PL/SQL scripts.
• Highly skilled and experienced in Agile Development process for diverse requirements.
• Experience in Design, Development, Implementation and support as Oracle Developer in Production, Development and Test Environments using Oracle Tools like SQL Developer and reporting services using Reports Builder, Crystal Reports and Oracle BI tools.
• Gave a scope for enhancements and Change management in place with agile methodology.
• Have extensively modeled data and created ER Diagrams using CA ERwin and Microsoft Visio.

TECHNICAL SKILLS

Database: Oracle 12c/11g/10g/9i, My SQL Server, DB2,Teradata

Languages: SQL, PL/SQL, UNIX Scripting

Development Tools: SQL Developer, SQL*Plus, TOAD, SQL*Loader, Reports Builder 10g/9i/6i, Forms Builder 6i/9i/10g, MS-Access 2000

Modeling tools: Erwin7.1/4.0,EmbarcaderoER/Studio, MSVisio

Reporting Tools: Crystal Reports, Oracle Reports, XML/BI Reports, MARS application

ETL: Informatica, Data Stage.

Others: XML, HTML, SVN, IBM Rational Clear case and Clear quest, Quality Center, Microsoft Visual Source Safe(VSS)

Operating Systems: Windows 2003/ XP/7, UNIX, AIX, LINUX, SUN SOLARIS

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Data Analyst

Responsibilities:

• Performed data analysis and gathered columns metadata of source systems for understanding requirement.
• Worked on End to End Data Analysis for integration of two systems.
• Responsible for Testing UI for preventive controls.
• Wrote SQL queries for back end controls.
• Responsible for Analyzing new columns and update to any existing new columns as part of migration.
• Responsible for reviewing BRD documents.
• Worked on Creating and maintaining Control inventory.
• Responsible for mapping documents for integration.
• Responsible for coming up with preventative controls in UI.
• Performedad hoc analyses, as needed, with the ability to comprehend analysis as needed.
• Responsible forAnalyzing report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel, Power Point.
• Developed custom visual reports, dashboards and KPI scorecards using Power BI desktop.
• Provided support & maintenance of Power BI reports to business users.
• Updated Data Inventory based on BRD Reviews.
• Used Teradata utilities like Fast Load, Multi Load to load data into temporary tables for analysis.
• Worked with Data Quality team users totweak the existing tests.
• Tracking the Data Quality tests requested through JIRA.
• Providing support for bug fixes and enhancements during release.
• Used Joinslike Inner Joins, Outer joins while creating tables from multiple tables.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Developed Complex SQL queries using common table expressions (CTE), temporary table to support Power BI and SSRS reports.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI reports.
• Performed data analysis and gathered columns metadata of source systems for understanding requirement.
• Wrote severalTeradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Used Joinslike Inner Joins, Outer joins while creating tables from multiple tables.
• Responsible for new Data Quality tests of our operational data.
• Created Data profiling routine.
• Extensively worked on to convertORACLE scripts into Teradata scripts.
• Compared Data in Oracle and Teradata to understand the Synchronizing issues existing between two Databases.
• Used Teradata utilities like Fast Load, Multi Load to load data into temporary tables for analysis.
• Generating Reports for our operational team ever week as part of data cleanup effort.
• Responsible for writing and running scripts for Data cleanup process.
• Partner with Tech teams during build, testing and release procedures.
• Work with the Party Operations on data clean-up efforts.
• Worked with Data Quality team to determine the cause for high data quality errors.
• CreatedMultiset, temporary, derived and volatile tables in Teradata database.
• Responsible for High Level Data Remediation Plans for Data Defects in our Operational data.
• Tuning SQL Queries to overcome spool space errors and improve performance.
• Worked on Teradata Multi-Load, Teradata Fast-Load utility to load data from Oracle and SQL Server to Teradata.
• Worked with Data Quality team on Preventive control catalog.

Environment: Teradata SQL Assistant, Excel, Ab initio, Jira.

Confidential, Charlotte, NC

Data Analyst

Responsibilities:

• Worked with various Business users togather reporting requirements and understand the intent of reports and attended meetings to provide updates on status of the projects.
• Communicating with the business users to understand business requirements clearly
• Responsible forAnalyzing report requirements and developing the reports by writing Teradata SQL Queries.
• Used Joinslike Inner Joins, Outer joins while creating tables from multiple tables.
• Tuned the queriesto improve the Performance of the existing reports for various functional areas.
• Performedad hoc analyses, as needed, with the ability to comprehend analysis as needed.
• Identifying data discrepancies and data quality issues and working to ensure data consistency and integrity
• Created Complex queries to use the logic of Z scores.
• Constant Interaction with ETL and MSTR team on requirements.
• Monitoring the Audit reports daily and keeping the business updated whenever there is huge variance in data.
• Responsible for keeping track of decommissions of the legacy reports
• Worked on queries using statistics to calculate the mean and average of the sales.
• Tracked the Data issues through JIRA
• Back tracking and Resolving queried raised by Users
• Responsible for the Decommission checklists for the legacy reports
• Prepared Test Cases and performed Unit Testing.
• Created Executive reports to show YTD Net Gain on the Sales.
• Creating wireframes and mockups for the presentation of reports to the team.
• Providing production support for bug fixes and enhancements.
• Identifying quality best practices and developing standard quality protocols that can be widely used in our Team.
• Agile Team Interaction
• Identifies business, operational and technical tasks, scope, time constraints and task interdependencies.

Environment: Teradata Studio, Excel, Ab Initio, MicroStrategy, Agile.

Confidential, Hartford, CT

Business Analyst/Data Analyst

Responsibilities:

• Requirement Gathering from Business Users.
• Analyzed client systems andBusinessprocesses.
• Created SQL scripts for demonstrating the prototypes and for verifying the result set
• Conducted and Managed JAD sessions with SMEs andBusinessdepartments, for planning and requirement gathering.
• Identifying and fetching the required test data based on thebusinessrules and rebalancing of client portfolios.
• Used Power Designer to develop Use Case diagrams, Activity Diagrams and Sequence Diagrams.
• Closely interacted with the technical team and made sure that the requirements are met.
• Worked closely with the QA team and reviewed test cases.
• Facilitated User Acceptance Testing withbusinessstakeholders to ensure all requirements has been met.
• Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing
• Worked on data modeling and produced data mapping and data definition documentation
• Provided Gap Analysis, documentedbusinessprocesses and directed UAT process.
• Extensively used SQL for Data Analysis.
• Follow up and closure of defects identified during the testing cycle with testing team and Development team.
• Conduct high-level analysis in specific areas of expertise, research and trouble shoot production issues, make suggestions to streamline operations.
• Analyzed existing Data Model and accommodated changes according to the business requirements.
• Created Conceptual model based on the business process and identified the entities, attributes and relationships and converted the conceptual model to the logical and physical data models.
• Converted the logical model to Physical Model by giving accurate data types, created indexes on keys and forward engineered the DDL.

Environment: Teradata, TOAD, Rally, Excel, Ms office, Ultra edit, Agile, Tableau, Oracle 11g, Erwin

Confidential, Brooklyn, NYC

Sr. Data Analyst

Responsibilities:

• Worked with SME’s and other stakeholders to determine the requirements to identify Entities and Attributes to build Conceptual, Logical and Physical data Models.
• Translated the business requirements into detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Created a high-level industry standard, generalized data model to convert it into logical and physical model at later stages of the project using Erwin and Visio.
• Extensively used SQL Query, joining tables, SQL function in Queries.
• Created numerous database objects like Tables, Sequences, indexes, views, materialized views, synonyms, etc., as per the business requirement.
• Used forward engineering to create a Physical Data Model with DDL, based on the requirements from the Logical Data Model.
• Wrote Stored Procedures and Triggers.
• Wrote Minus queries between source and target tables to check data integrity.
• Constant interaction with ETL team for the analysis.
• Assisted Business Analysts and Users during the UAT testing by providing the data dumps.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, and Detailed Design Documents.
• Wrote the count validation queries for source and target.
• Extensively used EXCEL and MS office.
• Did unit testing and development testing at ETL level in my mappings
• Used SVN for version controlling and ALM (Application Lifecycle Management) for ticketing system.
• Entering and updating issues using JIRA application.
• Created PL/SQL packages to extract and transform legacy data.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Worked on Metadata exchange among various proprietary systems using XML.
• Conducted Design reviews with the business analysts, content developers and DBAs
• Created database triggers for audit and data validation.
• Involved in creating ETL model (snowflake schema), normalizing and documenting.
• Involved in creating reports on other Tools like Tableau.
• Created summary tables using de-normalization technique to improve complex Join operations
• Created multiple dashboards, adhoc reports, sub-reports and complex master-detail reports using Reports.

Environment: Oracle Database 11g, PL/SQL, Erwin R8.2.5, MS Visio UNIX, Toad, Oracle Forms and Reports 11g, MS Office, ETL Informatica, Tableau, Excel.

Confidential, Redwood shore, CA

Data modeler/Data Analyst

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users.
• Map business needs/requirements to subject area model and to logical enterprise model.
• In order of better understanding the requirement documents, carried out couple of sessions with Management, SME (Subject Matter Expertise), vendors, users, and other stakeholders.
• Worked with Architecture team to get the metadata approved for the new data elements that are added for this project.
• Developed process methodology for the reverse engineering phase of the project.
• Developed project plan with project manager’s assistance for the first two phases of the project.
• Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: Erwin r7.1, Windows 2000/XP, Erwin 7.1, Oracle Database 11g, PL/SQL, Teradata, Sun Solaris, MS Excel 2007, Informatica 7.1.

Confidential, Akron, OH 

Data Modeler/Data Analyst

Responsibilities:

• Studied in-house requirements for the Data warehouse to be developed.
• Conducted one-on-one sessions with business users to gather data warehouse requirements.
• Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions
• Identified, formulated, and documented detailed business rules and Use Cases based on requirements analysis.
• Responsible for defining the naming standards for data warehouse.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT).

Environment: Erwin r7, Informatica 7.1.3, Windows XP/NT/2000, SQL Server 2005/2008, SQL, Oracle10g, DB2, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro