SUMMARY

• 8+ years of IT Experience as a Data Analyst, Business Analyst, and Data Modeler especially in Data Warehousing and Business Intelligence applications.
• Experience as a Business Analyst for data warehousing with a good knowledge and expertise in all phases of SDLC methodology including analysis, design, development, testing and maintenance.
• Extensive experience working with SQL & PL/SQL in creating stored procedures, views, triggers and database schemas.
• Proficient in Data Analysis on Oracle, MS SQL Server & MS Access with sound knowledge in extraction of data from various database sources like Oracle, MS SQL Server, DB2 and Flat files into the Data Stage.
• Experience in working with Sybase Power Designer for creating conceptual data model with entities, attributes, and relationships.
• Explored the reverse engineering features of Power Designer to create physical, conceptual and object - oriented models from an existing database.
• Experience in BI tools such as Business Objects, QlikView, Xcelsius, Crystal, OBIEE, ETL, Hyperion, Ab initio
• Knowledge of executing the projects in Agile methodologies.
• Well versed in system analysis, ER/Dimensional Modeling, Database design and implementing RDBMS specific features.
• Good in Normalization (1NF, 2NF, 3NF and BCNF)/Denormalization techniques for effective and optimum performance in OLTP and OLAP environments.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Exploited power of Teradata to solve complex business problems by data analysis on a large set of data.
• Efficient in process modeling using Erwin in both forward and reverse engineering cases.
• Well versed with Data Migration and Data Conversions using DTS, PL\ SQL Scripts.
• Experience in writing DDL, DML commands.
• Used TOAD for SQL developing.
• Experienced in conducting JAD Sessions.
• Experience in documenting Interface Agreement.
• Experience in using Visual Studio for GUI applications and Windows Forms applications.
• Experience in defining events within Business Process using Workflows.
• Very good exposure to ETL tools like Informatica, MicroStrategy and IBM Data stage.
• Extensive experience in the development, implementation and integration of strategies within a team oriented environment, utilizing quantitative and qualitative analytical skills.
• Excellent analytical, inter-personal and communication skills with clear understanding of business process flows.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, T SQL, Visual Basic 6.0, XML, HTML, Java.

Operating Systems: Windows (NT/XP/95/98/2000), UNIX, Sun Solaris, Mac OS.

Databases: Oracle 10g/9i/8i, SQL Server 2000/2005/2008 , PL/SQL, SQL*Plus, SQL*Loader, IBM DB2, MS SQL Server 2000/7.0/6.5 , MS Access 2000, Teradata V2R5.0.

Data Modeling Tools: Erwin, Sybase Power Designer, Clear quest, Rational Rose, MS Visio, ER Studio, Oracle BPA, SA - System Architect.

Reporting Tools: Business Objects 5.x / 6.5, Cognos 7.0/6.0, Crystal (6, 8, and 11), OBIEE Business Intelligence Enterprise edition 10.3.4.1, Hyperion.

Web Development Tools: Macromedia Dream Weaver4.0, Flash 5.0, Adobe Photoshop

ETL Tools: Informatica Power Center 8.6/7.1/6.2

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Sr. Data Analyst

Responsibilities:

• Gathered the requirements document and analyzed the process.
• Data profiling and analyzing the requirements and developing models using reverse engineering.
• Translate business requirements into conceptual, logical data models and integration data models, model databases for integration applications in a highly available and performance configuration using ER/Studio.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
• Performed GAP analysis with Teradata MDM and Drive (SQL) data models to get clear understanding of requirements.
• Used Base SAS, SAS/STAT, SQL and Macro facility to manipulate demographic, credit history and lifestyle data sets.
• Ensured the quality, consistency, and accuracy of data in a timely, effective and reliable manner.
• Worked within the larger Upstream ITSS organization by contributing to the capture of synergies and implementation of best practices.
• Analysed the existing as-is system for Insurance Personal Lines, tracked defects, provided recommendations to make enhancements in the future to-be system.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
• Experience in understanding user requirements around technical data, interaction of data between systems and system dependencies.
• Prepared and distributed Escalation Report and Daily Metrics through SAP (Business Object Web Intelligence) for the manager for Business improvement purpose.
• Worked to ensure high levels of data consistency between systems.
• Worked with the global technical data community and assist with implementing the global data management strategy.
• Involved in developing many Dash Boards for home, rental and auto insurance.
• Worked with Oracle SQL Developer to develop the SQL scripts.
• Developed PL/SQL programming that included writing Views, Stored Procedures, Packages, Functions and Database Triggers.
• Experience in developing Web applications using Visual Studio.Net, C# and InterSoft WebGrid
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• Automate periodic reports using Excel VBA, SQL server, Hyperion, Essbase, SSIS Package for management team.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project.
• Prepared analytical and status reports and updated the project plan as required.

Environment: Oracle SQL Developer, MS Access, Base SAS,VBA, Teradata, Informatica Power Center 4.7, ER/Studio Data Architect 9.0, SSIS, Windows XP, Excel, Business Objects, Crystal Reports.

Confidential, Wilmington, DE

Sr.Data Analyst

Responsibilities:

• Worked with the Business analyst for gathering requirements.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Used UML and Visio for creating Activity diagrams, Sequence Diagrams.
• Used Erwin for relational database and dimensional data warehouse designs.
• Developed entity and attribute descriptions and definitions for the models and ensure that conflicts in descriptions and definitions are resolved.
• Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
• Conducted design discussions and meetings to come out with the appropriate data mart using Inmon methodology.
• Converted SAS code to TSQL and generated reports using migrated code.
• Worked with Master Data Management architects to develop data models.
• Use SAS to load and extract data from various data sources.
• Writing complex queries using Teradata SQL.
• Involved in writing code using Base SAS & SAS/Macros to clean and validate data from tables.
• Used BTEQ for SQL queries and TPump for loading data from source into Teradata tables.
• Used Teradata utilities such as Fast Export, MLOAD for handling various tasks.
• Performed source data quality assessments.
• Experience in Data Transformation and data cleansing.
• Identified the objects and relationships between the objects to develop a logical model in Erwin tool.
• Translated the logical model into physical model using Forward Engineering technique in Erwin tool for both OLAP and OLTP systems.
• Created Data Definitions and help maintain Metadata repository.
• Defined and processed the facts and dimensions.
• Created DDL scripts for static dimensions and ETL mappings using Informatica.
• Utilized Erwin for reverse engineering the database from DDL scripts.
• Assisted the Data Acquisition Architect to ensure the Data Architecture is applied properly.
• Involved in resolving the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Developed PL/SQL programming that included writing Stored Procedures, Packages, Functions and Database Triggers.
• Experience in using SSIS in solving complex business problems.
• Experience in using SSRS and Cognos in creating and managing reports for an organization.
• Created documentation, worked with users for new module enhancements and testing.

Environment: PL/SQL, SQL Server 2008, SSIS, Oracle 10g, MS SQL, VBA, Teradata, Informatica Powercenter, Erwin r7.3, Windows XP, Excel.

Confidential, Columbus, OH

Sr. Data Modeler/Data Analyst/Developer

Responsibilities:

• Involved in gathering user requirements along with business analysts.
• Involved in a team conducting data modeling JAD sessions and logical data analysis, communicated data-related standards.
• Created documentation for Technical & Business User Requirements during requirements gathering sessions using Rational Requisite Pro.
• Identified and validated high potential business opportunities for stakeholders and developed customized business strategies that are aligned with corporate strategic objectives.
• Transformed project data requirements into project data models for OLAP and OLTP systems using Erwin.
• Prepare prototype models to support the development efforts. Assist the business analyst in mapping the data from source to target.
• Involved in modeling business processes through UML diagrams using Rational Rose.
• Conducted logical data model walkthroughs and validation.
• Extensively worked on Shell scripts for running SAS programs in batch mode on UNIX.
• Facilitated transition of logical data models into the physical database design for data marts using Inmon methodology and recommended technical approaches for good data management practices.
• Performed the activities necessary to support the standardization of facts and dimensions.
• Developed various use case diagrams using MS Visio.
• Created entity relationship diagrams, functional and data flow diagrams. Developed the data mart for the proposed project.
• Used Sybase power designer tool for relational database and dimensional data warehouse designs.
• Analyze the existing data model and document suspected design affecting the performance of the system.
• Worked with DBA group to create Physical Data Model from the Logical Data Model using Forward engineering in Erwin.
• Reverse Engineered the database structure from the existing application using Sybase power designer.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Documented data content, data relationships and structure, and processes the data using Informatica PowerCenter Metadata Exchange.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Wrote DDL and DML statements for creating, altering tables and converting characters into numeric values.
• Turned SQL queries to make use of data base indexes, and analyzed the data base objects.
• Used SSIS, SSRS for solving business problems and creating reports in organization.
• Created a report using Hyperion based on the data model.
• Involved in the mapping of data sources and analytics, with the goal of ensuring data quality.
• Expert in data cleansing for accurate reporting. Thoroughly analyze data and integrate different data sources to process matching functions.

Environment: Rational Requisite Pro, Informatica, PL/SQL, MS SQL, SQL Server 2008, Sybase 12, Ms Visio, Business Objects, Windows NT, Linux, UNIX,Sybase Power Designer.

Confidential

Data Analyst

Responsibilities:

• Involved in gathering user requirements along with business analysts.
• Conducted logical data analysis and data modeling JAD sessions, documented data-related standards.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Make use of data modeling techniques in designing the data marts project.
• Used Rational Rose 2000 for Object Modeling in UML.
• Created views and extracted data from Teradata base tables and uploaded data to oracle staging server from Teradata tables, using fast export concept.
• Gather all the Sales Analysis report prototypes from the business analysts belonging to different Business units.
• Gather the various requirement matrices from the business analysts.
• Worked with Master Data Management.
• Assisted the DBA in converting the logical models to physical.
• Conduct Design discussions and meetings to come out with the appropriate Data Mart using Kimball Methodology.
• Released the reports through UNIX shell scriptingevery month based on requirement
• Designs for the various reporting requirements.
• Conduct Design reviews with the business analysts, content developers and DBAs to ensure the feasibility of the designs.
• Used Erwin for developing data model and forward engineer the data model.
• Reverse engineer the data base in to physical data model by using Erwin.
• Developed entities and relationships using Sybase Power Designer.
• Developed Data Migration and cleansing rules for the integration architecture.
• Developed data mapping documents between legacy, production and user interface systems.
• Designed different type of STAR schemas like detailed data marts, Plan data marts,
• Used Erwin for monthly summary data marts and inventory data marts.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: Oracle 8i, Windows NT, ER-Win 4.0, Sybase Power Designer, Teradata, UNIX, SQL Loader, Data Junction, Rational Rose 2000, Oracle Express Server.