SUMMARY:

• Over 10 years of professional experience in data analysis, designing, and data modeling.
• Excellent command over Logical and Physical entity relationship data modeling using CASE tools
• Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments
• Involved in Data Warehouse design and implementation
• Created Cubes using Dimensional (Star and Snowflake) data modeling and identified Facts and Dimensions
• Experience in working wif OBI administration tool developing metadata repository and strong experience in working as OBIEE financial analyst. Experience in all phases of Data Modeling - Conceptual, Logical and Physical modeling.
• Extensive experience in SQL Server, MS Access, Sybase, Oracle 9i/8i/7.x programming using PL/SQL,TSQL and standard built-in Oracle package in a Unix environment.
• Expertise in Data Modeling using tools likes ERwin, ER/Studio and MS Visio along wif the hands on experience in using Forward and Reverse engineering functionality.
• Experience in working wif industry standard analysis techniques to uncover client requirements and identifying the roles and deliverables in the Organization by creating Use Case Models, Data Flow Models, Workflow Analysis, Functional decomposition Analysis, Object Modeling along wif Activity Diagrams, Sequence Diagrams and State Diagrams using Rational Rose and Microsoft Visio. Experience to work in both, business and technical areas, to deliver optimal business process solutions.
• 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
• Well versed wif Data Migration, Data Conversions, Data Extraction/ Transformation/Loading (ETL) using DTS, PL\ SQL, TSQL Scripts
• Experience in designing and developing Data Warehouse applications using ETL and Business Intelligence tools like Informatica Power Center (8.1/7.x/6.x/5.x) /Power Mart 4.7, Datastage, Mainframes SAS, SSAS, SSIS, OLTP,OLAP, Business Objects.
• Experience wif Data warehouse applications using Oracle, MS SQL Server on windows and UNIX platforms.
• Having experience in Project management in Oracle EBS including OBIEE.
• Implementation and Support of various applications in OLTP and OLAP applications.
• Proficient in the use of tools like Tele logic DOORS, Rational Rose, Requisite Pro, Rational Clear Case, Tele logic System Architect and MS Visio.
• Experience in WebLogic 8.1/9.x, Jboss 4x/5x and Tomcat servers.
• Experience wif Web Service, ESB and OSB products (Oracle SOA Suite, BEA Aqualogic, Weblogic server, etc.)Basic Security Profile etc.
• Experience in financial and insurance domain.
• Created Decision Support System Reports
• Well versed wif various software development methodologies (SDLC, Extreme Programming, MSF)
• Good command in modeling using case tools like ERwin, Oracle Designer, Power Designer & E-R/Studio.
• Understanding of BEA WebLogic Portal to simplify the production and management of custom-fit portals, allowing a shared services environment to roll out changes wif minimal complexity and effort.
• Experience wif Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS and Bulk Insert (BCP).
• Good exposure to XML, SOAP, Web Services
• Experienced in designing, developing and implementing database monitoring on Unix Platform using Unix Shell Scripts.
• Experience wif Relational Databases like Oracle 10g/9i/8i, DB2 ESE, VSAM, MS SQL Server 2005/2000, DBA, DTS, Sybase, Teradata V2R5, MS Access and formats like flat-files, CSV files, COBOL files and XML files.
• Well versed wif SDLC software development life cycle. Experience in dealing wif different data sources ranging from Flat files, Oracle, Sybase, SQL server, Teradata, Ms Access and Excel.
• Excellent analytical, inter-personal and communication skills wif 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, SAS, SSIS, SSAS

Database Development: T-SQL and PL/SQL

Software Engineering: UML using Visio

Testing Tool: QTP, Quality Center

Web/App. Servers: Tomcat 6x/7x and WebLogic

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, Florham Park, NJ

Data Analyst

Responsibilities:

• Gatheird business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of the existing Broker Portal system.
• Involved in developing Logical Data Models and conducted brainstorming sessions wif project focus groups.
• Conducted JAD sessions wif 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.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Worked wif DBA group to create Best-Fit Physical Data Model from the Logical Data Model using Forward engineering using Oracle Designer.
• Organized Joint Application Development (JAD) sessions wif data steward and ETL teams while having walkthroughs for mapping documents.
• Developed SSIS Packages and SQL scripts to extract the data from OLTP system to flat files and for pre-calculated aggregates, summaries, and user specific calculations.
• Migration of DTS to SQL Server Integration Service (SSIS).
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Generated the first cut physical design.
• Involved in designing and developing Data Models and Data Marts dat support the Business Intelligence Data Warehouse.
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Created jobs sequences.
• Technically lead software development using WinForms, SharePoint, Service Oriented Architecture (Web services, SOAP, XML), Data Warehousing and SQL Server technologies using VB.Net and ASP.NET.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Experience wif data migration (ETL development), document data manipulation processes and scripts
• Created job schedules to automate the ETL process.
• Enhanced the job properties for performance tuning.
• Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.
• Market Data Clearing House (American Electric Power) Gatheird requirements and designed the database used Erwin for normalized (3 NF) Physical Data Model. Data extracted from the legacy system in ASCII format and forwarded to Logica Inc.
• The ASCII file header validated through a Unix Shell and loaded into oracle tables by SQL LOADER. And PL/SQL procedures validate the records and upload into relational tables.
• Worked wif a fellow team member to train them on the use of the software.
• Finished the bulk of the domain data model
• Prepared the documentation of Data Acquisition and Interface System Design.

Environment: Windows NT 4.0, Oracle 9i, OBIEE, Business Intelligence, ETL, Oracle Designer, PL/SQL, SSIS, DOS and UNIX shell scripting, Sequential Files.

Confidential, Wayne, PA

Data Analyst

Responsibilities:

• Involved in requirement gathering along wif 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
• Gatheird all the Sales Analysis report prototypes from the business analysts belonging to different Business units
• Gatheird various requirement matrices from the business analysts
• Participated in Joint Application Development(JAD) sessions
• Conducted Design discussions and meetings to come out wif the appropriate Data Mart
• Designed for the various reporting requirements
• Researched, Analyzed, designed, developed Java Web Services Service Oriented Architecture (SOA).
• Captured and documented system level (SSS) and software level (SRS) requirements in DOORS supporting the SOW and system design for the SCL3S Airborne Communcations program.
• Provided technical knowledge and understanding of specific infrastructure technologies including: Unix (Sun & AIX), Wintel, VMWare/ESX, Citrix/Metaframe, Web (IIS & Weblogic), Shared Storage (SAN, NAS, SATA), Veritas, SCADA.
• 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 wif the business analysts, content developers and DBAs
• 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 (wif 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.
• 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).

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

Confidential - Detroit, MI

Sr. Data Analyst

Responsibilities:

• Gatheird and Translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality
• Developed project plan wif project manager’s assistance for the first two phases of the project.
• Installed and configured of SQL Server 2000 cluster in windows environment
• Data modeling and design of databases, tables and all objects.
• TSQLand SSIS objects using SQL Agent.
• Designed hundreds of complex queries to substantially reduce labor and improve data quality. One query alone discovered over 50,000 possible duplicate client records, resulting in reduced mailing costs, improved business intelligence, and enhanced customer experience.
• Eliminated 90% of manual data entry and manual quality control in my department by improving workflow and data methods which accelerated data availability. Performed Data Modeling by creating Logical and Physical models of the database system in ERwin.
• PerformedForward Engineering to generate DDL scripts and Reverse Engineering of the Data Models.
• Worked wif the DBA and Database developers to convert the functional specification to technical specification and generate the data model.
• Wrote complex queries involving in SQL, ORACLE, DB2 for LUW and DB2.
• Successfully transitioned data entry duties to offshore facility, resulting in a staff reduction of four FTE (full time equivalents.) Continued to remotely manage and monitor this new group.
• Identified objects and relationships and how those all fit together as logical entities, these are tan translated into physical design using the forward engineering ERWin tool.
• Providing expert troubleshooting for isolating technical problems in SOA/OSB systems including Weblogic application servers, OHS web servers, and dehydration databases on RAC.
• Effectively analyzed business requirements, technical specifications and technical issues to generate test plans and test cases.
• Develop complex Teradata SQL queries to generate ad-hoc reports for the business analysts of Bank of America (BofA) to implement complex business rules.
• Utilized process-based test management system Quality Center for organizing test requirement's documents.
• Experience wif Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS and Bulk Insert (BCP).
• Assisted the IT team to develop service oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.
• Supported SOA, data warehousing, data mining, and Enterprise Service model standards in designs, and developed standardization of processes like configuration management.
• Mapping the columns from Oracle to SQL Server sing SSIS.
• Converted existing DTS packages to SSIS packages.
• Prepared the Joins/Filter logic documents dat would help the ETL design team perform the Joins on the tables dat are in the form of flat files before loading them to FDS or any downstream systems.
• Assisted PM in OBIEE implementation by leading team of five analysts to develop implementation artifacts including security and administration procedures tool-usage best practices and training documentation.
• Worked closely wif the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects dat support the business requirement and process.
• Determine whether unexpected Exceptions are application or WebLogic exceptions
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Created and worked wif X-Reference tables for data validation between difference data marts/Databases
• Bugs reported to developers using Quality Center.
• Designed and implemented the security for the databases.
• 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.
• Created DTS packages for implementing our ETL strategy
• Migrated data from SQL Server to Oracle and uploaded as XML-Type in Oracle Tables.
• Used XML for metadata exchange between various proprietary systems
• Implemented the reporting sub system via Crystal Reports

Environment: Quality Center, Teradata, OBIEE, Perl, SQL Server 2000,T-SQL, SOA, Tomcat, Sybase, ETL, Oracle, Business Intelligence,SSIS, Unix Shell Scripting,, Analysis Services, DOORS, Weblogic, Crystal Reports7.5/8.0, Windows 2003, ERWin, XML

Confidential, Baltimore, MD

Data Analyst

Responsibilities:

• Gatheird the business requirements by conducting a series of meetings wif 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.
• Added new functionto the cubewifMDX
• Developed UNIX Shell Scripts to load the data and implemented cron jobs to execute scripts automatically.
• Designed data models wif GE- ERC standards up to 3rd NF (OLTP/ODS) and de normalized (OLAP) data marts wif Star & Snow flake schemas.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Created reports using SQL Server Reporting Services (SSIS).
• 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, TSQL, 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)
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along wif developing and documenting process flows for business processes.
• Experience on Extraction Transformation and Loading (ETL) process using SSIS
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Used Sybase Power Designer for creating tables using Forward Engineering.
• Used Star Schema and Snow flake Schema for data marts / Data Warehouse.
• Prepared the Joins/Filter logic documents dat would help the ETL design team perform the Joins on the tables dat are in the form of flat files before loading them to FDS or any downstream systems.
• Identify unexpected exceptions and the WebLogic Server instance dat generated the exception
• Used DOORS to link requirements to test cases, business rules, design items to maintain traceability.
• Created documentation and test cases, worked wif users for new module enhancements and testing.
• Involved in Service Oriented Architecture (SOA).
• 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 wif business analyst to design weekly reports using Cognos Report Net.
• Reduced labour intensive manual processes like job entry, approval and invoicing by exposing well-defined SOA interface allowing B2B integration wif Financial Clients
• Worked on building load rules and transformation logic for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.
• Understood existing data model and documented the performance of the system.
• Validated the model wif response to questionnaire from analysts.

Environment: Windows NT, Weblogic, Sybase, SOA, Sybase Power Designer, TSQL, MDX,SSIS, Tomcat 9.2,DTS, Oracle, ETL, Rational Rose, Unix shell Scripting, DOORS, Cognos Report ne.