SUMMARY:

• 6+ years of professional experience as a Data Analyst in Finance and Insurance domain.
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Created Cubes using Dimensional (Star and Snowflake) data modeling and identified Facts and Dimensions
• Proficient in gathering business requirements and handling requirements management
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Designed the ETL system for populating the Datawarehouse from the operational DBMS
• Experience in Data Warehousing using ETL tools like Informatica & Teradata and reporting tools like Business Objects for business intelligence.
• Well versed with Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS, PL\ SQL Scripts
• Experience in designing and developing Data Warehouse applications using ETL and Business Intelligence tools like Informatica Power Center, Datastage, Mainframes SAS, SSAS, SSIS, OLTP,OLAP, Business Objects.
• Experience with Data warehouse applications using Oracle, MS SQL Server on windows and UNIX platforms.
• Experience in Other Utilities/Tools/Scripts like Korn Shell Scripting, Perl 5.0, SQL Plus, SQL Loader, Export and Import utilities, TOAD 9.1 and Visio 10.0.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Proficient in the use of tools like Tele logic DOORS, Rational Rose, Requisite Pro, Rational Clear Case, Tele logic System Architect and MS Visio.
• Well versed with various software development methodologies (SDLC, Extreme Programming, MSF)
• Good command in modeling using case tools like ERwin, Oracle Designer, Power Designer & E - R/Studio.
• Experience with Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS and Bulk Insert (BCP).
• Experience with Relational Databases like Oracle 10g/9i/8i, DB2 ESE, VSAM, MS SQL Server 2005/2010, DBA, DTS, Sybase, Teradata V2R5, MS Access and formats like flat-files, CSV files, COBOL files and XML files.
• Well versed with SDLC.
• Experience in dealing with different data sources ranging from Flat files, Oracle, Sybase, SQL server, Teradata, Ms Access and Excel.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flow.

TECHNICAL SKILLS:

Database Systems: SQL Server (2005/2000/7.0 ), Access 2003,Oracle (9i/8i/7.x), Sybase ASE 12, IBM DB2/UDBa, MySQL, Teradata

Data Modeling Tools: ER/Studio, ERwin, Oracle Designer, Power Designer, Rational Rose, and Visio

Datawarehousing: Microsoft OLAP Service, Data Marts

Data Mining: SAS Enterprise Miner and Knowledge Seeker

Reporting: Crystal Reports and SQL Server 2000/2005 reporting services

ETL Tools: Informatica 8.1/7.x/6.x/5.x., Data Stage, XSD, SAS, SSIS, SSAS

Database Development: T-SQL and PL/SQL

Software Engineering: UML using Visio

Testing Tool: QTP, Quality Center

Office Applications: MS Office (Word, Excel, PowerPoint)

Source Code Control: Visual Source Safe and Concurrent Version Control

Web Development: HTML, XML and FrontPage

Operating Systems: Windows (Me, XP), Solaris, Linux, Unix

Programming Languages: C#, Visual Basic.NET, Java and C++, Perl

PROFESSIONAL EXPERIENCE:

Confidential, OH

Data Analyst

Responsibilities:

• Gathered and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
• Developed project plan with project manager’s assistance for the first two phases of the project.
• Installed and configured of SQL Server 2000 cluster in windows environment
• Analyzed and documented the system specifications, Business requirements; used the tool DOORS for documenting, tracking and analyzing the requirements.
• Modify existing Informatica mappings to utilize Power Exchange sources and Oracle and Netezza targets.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Incorporated the Informatica Velocity approach for Mapping design, development and Data Governance
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering ERWin tool.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects
• Effectively analyzed business requirements, technical specifications and technical issues to generate test plans and test cases.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Develop complex Teradata SQL queries to generate ad-hoc reports for the business analysts of Bank of America (BofA) to implement complex business rules.
• Experience with Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS and Bulk Insert (BCP).
• Used Universal Data Modeling Techniques to assist Novell Inc, in designing their Data Warehouse/Data Marts and Metadata Management Solution that will integrate Oracle Financials.
• Assisted the IT team to develop service oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.
• Worked closely with Testing team and helped in testing the Informatica mappings, workflows, AbInitio Graphs and Teradata scripts
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Supported SOA, data warehousing, data mining, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.
• Participated in writing data mapping documents and performing gap analysis to verify the compatibility of existing system with new business requirements
• Worked on Master Data Management (MDM) for maintaining the customer information and also for the ETL rules to be applied.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Helped in migration and conversion of the Sybase database into SQL Server database.
• Use of data transformation tools such as DTS, SSIS, Informatica or DataStage.
• Responsible for the collection of functional requirements, non functional requirements, data mapping, and light data modeling.
• Created DTS and SSIS packages to load data from different file sources, such as text file, excel sheets.
• Created Informatica mappings with T-SQL procedures to build business rules to load data.
• Developed data enterprise teams and infrastructure environments from inception to steady state with focus on data architecture, data modeling, DBA development and operations, metadata management, and data quality.
• Performance tuned the database which includes indexes and optimized SQL statements, after monitoring the SQL server using the Profiler.

Environment: Quality Center, Teradata, Perl, SQL Server 2000, XSD, SOA, Sybase, ETL, Oracle, SSIS, Unix Shell Scripting,, Analysis Services, Teradata, DOORS, Crystal Reports7.5/8.0, Windows 2003, Perl, ERWin, XML

Confidential, Plano TX

Data Analyst

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users.
• Involved in business process modeling using UML through Rational Rose.
• Created logical data model from the conceptual model and it’s conversion into the physical database design.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Created reports using SQL Server Reporting Services (SSIS).
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Responsible for creating mapping documents required for the ETL team.
• Developed SSIS Packages to transfer the data between SQL Server database and files.
• Created SQL, PL/SQL, SQL Loader control files, functions, procedures, and UNIX Shell scripts.
• Been a part of Architecture and modeling team and have used SOA (Service Oriented Architecture)
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Experience on Extraction Transformation and Loading (ETL) process using SSIS
• Conduct data mapping sessions, and write the required business requirements documentation including use cases.
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Used Star Schema and Snow flake Schema for data marts / Data Warehouse.
• Prepared the Joins/Filter logic documents that would help the ETL design team perform the Joins on the tables that are in the form of flat files before loading them to FDS or any downstream systems.
• Used DOORS to link requirements to test cases, business rules, design items to maintain traceability.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Used SQL Server 2005 tools like Management Studio, Query Editor, Business Intelligence Development Studio (BIDS) including SSIS and SSRS.
• Created job schedules to automate the ETL process
• Normalized the database up to 3NF to put them into the star schema of the data warehouse.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Worked with business analyst to design weekly reports using Cognos Report Net.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Reduced labour intensive manual processes like job entry, approval and invoicing by exposing well-defined SOA interface allowing B2B integration with Financial Clients
• Worked on building load rules and transformation logic for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.

Environment: Windows NT, Sybase, SOA, Sybase Power Designer, SSIS, DTS, XSD, Oracle, ETL, Rational Rose, Perl Scripting, Unix shell Scripting, DOORS, Teradata, Cognos Report net.

Confidential, NJ

Data Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of the existing Broker Portal system.
• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Conducted JAD sessions with management, SME (Subject Matter Expert), vendors, users and other stakeholders for open and pending issues to develop specifications.
• Defined the calculations based on the reporting needs and the source data available
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Organized Joint Application Development (JAD) sessions with data steward and ETL teams while having walkthroughs for mapping documents.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Performed data modeling to correct problems with the current Sybase database. In addition, optimized current stored procedures and triggers to expedite the loading process.
• Database table review and data mapping for large scale data conversion project Oracle database to Mainframe.
• Created Data Dictionary and ER diagrams for data mapping purposes.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Use of data transformation tools such as DTS, SSIS, Informatica or Data Stage.
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Developed business requirement specification documents as well as high-level project plan.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Prepared a handbook of standards and Documented standards for Informatica code development.
• Experience with data migration (ETL development), document data manipulation processes and scripts
• Created job schedules to automate the ETL process.
• Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.
• Worked with a fellow team member to train them on the use of the software.
• Prepared the documentation of Data Acquisition and Interface System Design.

Environment: Windows NT 4.0, Oracle 9i, ETL, Teradata, Perl, Oracle Designer, PL/SQL, XSD, SSIS, DOS and UNIX shell scripting, Sequential Files.

Confidential, Wayne, PA

Data Analyst

Responsibilities:

• Involved in requirement gathering along with the Business Analysts Group
• Designed the data marts using the Ralph Kimball’s Dimensional Data Mart modeling techniques
• Involved in Object Modeling in UML Using Rational Rose 2000
• Gathered all the Sales Analysis report prototypes from the business analysts belonging to different Business units
• Conducted Design discussions and meetings to come out with the appropriate Data Mart
• Designed for the various reporting requirements
• Researched, Analyzed, designed, developed Java Web Services Service Oriented Architecture (SOA).
• Developed Functional and Regression Testing scenarios based on XML and XSD schema validations.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Designed, developed and tested data mart prototype (SQL 2005), ETL process (SSIS) and OLAP cube (SSAS) for Computer Maintenance Management System (CMMS)
• Use of data transformation tools such as DTS, SSIS, Informatica or DataStage.
• Conducted Design reviews with the business analysts, content developers and DBAs
• Designed, developed, and maintained Enterprise Data Architecture for enterprise data management including business intelligence systems, data governance, data quality, enterprise metadata tools, data modeling, data integration, operational data stores, data marts, data warehouses, and data standards.
• Designed different type of STAR schemas like detailed data marts and Plan data marts
• Researched, Analyzed, designed, developed Java Web Services Service Oriented Architecture (SOA).
• Monthly Summary data marts, Inventory data marts using Erwin (with various Dimensions Like Time, Services, Customers, Sales Hierarchy, Orders Snow flake Dimensions and various FACT Tables)
• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in DataStage, and creating ETL jobs in DataStage.
• Worked on data modelling and produced data mapping and data definition documentation
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically
• Worked on SQL Server 2005 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Using Shared Containers and creating reusable components for local and shared use in the ETL process.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase

Environment: SQL Server 2000, Windows NT, ERWin 4.0, MS-DTS, SQL*Loader, XSD, SSIS, Data Junction, Oracle, Rational Rose 2000