Summary

• 7 years of IT experience in the field of Business/Data analysis, ETL Development, Data Modeling, and Project Management.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services and Configuration Management
• Over 3 years of experience in Data Modeling with expertise in creating Star Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin and Sybase Power Designer.
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Knowledge in Business Intelligence tools like Business Objects, Cognos and Oracle Discoverer
• Strong experience in interacting with 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 various phases of Software Development life cycle Analysis, Requirements gathering, Designing with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Experience in conducting Joint Application Development JAD sessions for requirements gathering, analysis, design and Rapid Application Development RAD sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project's exposure to the forces of change
• Experience in coding SQL/PL SQL using Procedures, Triggers and Packages.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies
• Worked on different platforms such as Windows 95/windows/98/NT and UNIX, Sun Solaris, AIX, HP
• Experience in Working with different industries like Financial, Insurance and Banking.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side
• Experience with Unix Shell Scripting in vi and Pico editor
• Experience in creating functional/technical specifications, data design documents based on the requirements
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

Technical Skills

• ETL TOOLS: Informatica Power Center, SQL Loader, Ascential Data Stage
• DATA MODELING: Erwin 4.0, Power Designer, Microsoft Visio 2003, ER Studio
• DATABASES: Oracle 9i, 10g, MS SQL Server, MS Access, Teradata
• OPERATING SYSTEMS: Windows and UNIX, Sun Solaris, AIX, HP
• PROGRAMMING LANGUAGES: SQL, PL/SQL, Visual Basic, Net, C, C , UNIX Shell Scripting, XML
• REPORTING/DSS/ANALYSIS: Business Objects 5.0, COGNOS 7.0 and Crystal Reports

Professional Experience

Confidential

Sr.Data Analyst

Confidential I was involved in designing and building Confidential data marts required for Business Intelligence team to report the daily/weekly/monthly WMS and Central Refill Pharmacy information . Also be used to perform data processing/analysis needed for other reporting teams across the board. Also WMS CRP data mart used for Compliance/Auditing and ad-hoc reporting

Responsibilities:

• Creation of Teradata BTEQ, fastLoad, Fast export scripts and UNIX shell scripts to perform the fulfillments Creation of Tables, Views to fulfill the business needs and support the Production systems with day to day activities and support the performance issues.
• Developed SQL, BTEQ Teradata queries for Extracting data from production database and built data structures, reports.
• Used the MS Excel, MS Access for data pulls and ad hoc reports for analysis.
• Performance tuning and Optimization of large database for fast accessing data and reports Ms Excel
• Unix, Oracle, Teradata being used for data transformation
• Reports generated for various departments like Tele Marketing, Mailing, New Accounts by using SQL, BTEQ, Ms Access, Unix
• Ad-hoc reports developed using Oracle, SQL, and UNIX.
• Performed in depth analysis in data prepared weekly, biweekly, monthly reports by using SQL, SAS, Ms Excel, Ms Access, and UNIX.
• Extensively used excel and VBA to generate reports
• Created and manipulated datasets using SAS, Access, and Excel.
• Wrote JCL programs to communicate with the MVS TSO, ISPF operating system.
• Designed and implemented SQL queries for QA Testing and Report / Data Validation
• Assisted in preparing BRDs, FRDs, and Test Cases.
• Design Extract Transform load ETL procedures for data import and Manipulation.
• Worked with data modelers and assist them in verifying and validating the relationships between tables using Teradata SQL assistant.
• Execution, Maintenance Debugging of the scripts with Teradata Bteq.
• Execution, Maintenance Debugging of SAS scripts to update the Teradata Tables
• Create Teradata tables, Views, Macros and analyzed various Teradata tables for UPI's and Monitor the same.
• Utilized ODBC for connectivity to Teradata MS Excel.

Environment: Teradata 13.1, Informatica 6.2.1, Ab Initio, Business Objects, Oracle 9i, PL/SQL, Microsoft Office Suite Excel, Vlookup, Pivot, Access, Power Point , Visio, VBA, Micro Strategy, Tableau ,UNIX Shell Scripting ERWIN.

Confidential

Sr. Data Analyst

As a Sr. Data Analyst, I was Involved in building Impact Data Mart IDM from the existing Analytic Data Warehouse Confidential data with supporting Buyer and Catalogue information. Also data mart required for various reporting purposes BI Adhoc Reporting

Responsibilities:

• Met with Customers to determine User requirements and Business Goals.
• Blended technical and business knowledge with communication skills to bridge the gap between internal business and technical objectives and serve as an IT liaison with the business user constituents.
• Conducted JAD sessions to gather requirements, performed Use Case and work flow analysis, outlined business rules, and developed domain object models
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database
• Created a conceptual design based on the interaction with the functional and technical team.
• Analyzed the existing data model and incorporated new additions for the advancement data into the data model identifying the cardinality of the new tables to the existing tables and ensure proper referential integrity of the system
• Analyzed, created and formatted the Reports as per Business Requirements.
• Analyzed and created various adhoc Reports for users based on User Requirements.
• Created both list and drill down reports identifying the data hierarchy
• Performed report validation writing SQL queries using TOAD on an Oracle database.
• Created process documents, reporting specs and templates, training material and slideshow presentations for the application development teams and managements
• Analysis of the data identifying source of data and data mappings of BHC.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic.
• Interact with the SME's to analyze the data extracts from Legacy Systems Mainframes and COBOL Files and determine the element source, format and its integrity within the system
• Transformation of requirements into data structures which can be used to efficiently store, manipulate and retrieve information
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Ensure that models conform to established best practices including normalization rules and accommodate change in a cost-effective and timely manner.
• Created and maintained specifications and process documentation to produce the required data deliverables data profiling, source to Client maps, flows .
• Worked in collaboration with various areas of the organization, identified additional stakeholder Requirements, and Documented requirements in a Software Requirements Specification document.
• Created use cases, activity diagrams and state diagrams using Rational Rose.

Environment: Oracle 10g, Windows, Microstrategy, MS Visio, MS Project, Informatica

Confidential

Data Analyst

determining the assets that are eligible for financing and securitization, from multiple sources and the method of obtaining and storing data.

Responsibilities:

• Work with users to identify the most appropriate source of record required to define the asset data for financing
• Perform data profiling in the source systems that are required for financing
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Involved in defining the trumping rules applied by Master Data Repository
• Define the list codes and code conversions between the source systems and MDR.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Responsible for defining the key identifiers for each mapping/interface
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Involved in configuration management in the process of creating and maintaining an up-to-date record of all the components of the development efforts in coding and designing schemas
• Developed the financing reporting requirements by analyzing the existing business objects reports
• Interact with computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements. .
• Responsible in maintaining the Enterprise Metadata Library with any changes or updates
• Document data quality and traceability documents for each source interface
• Establish standards of procedures.
• Generate weekly and monthly asset inventory reports.
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality
• Remain knowledgeable in all areas of business operations in order to identify systems needs and requirements.

Environment: SQL/Server, Oracle 9i, MS-Office, Teradata, Informatica, ER Studio, XML, Business Objects

Confidential

Database Developer

Confidential is one of the largest banks in India. Confidential offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels and through its specialized subsidiaries and affiliates in the areas of investment banking, life and non-life insurance, venture capital and asset management. ICICI Bank is considered to be the most valuable bank in India in terms of market capitalization.

Responsibilities:

• Involved in the design of the overall database using Entity Relationship diagrams.
• Wrote triggers, menus and stored procedures in PL/SQL.
• Involved in developing interactive forms and customization of screens using Forms 4.5.
• Involved in building, debugging and running forms.
• Involved in Data loading and Extracting functions using SQL Loader.
• Designed and developed all the tables, views for the system in Oracle.
• Designing and developing forms validation procedures for query and update of data.

Environment: Oracle 8.0, SQL plus, SQL Loader, PL/SQL, Forms 4.5, Reports 2.5