SUMMARY

• Around 7 years of experience in Financial and Corporate Information Systems with an excellent track record in data collection, data analysis and data evaluation.
• Strong experience of being a liaison between the internal team and external clients, ensuring production of effective campaign lists.
• Data warehouse, ETL - Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
• Strong knowledge and working experience with Microsoft SQL Server database and SSMS.
• Experience in system development lifecycle including business intelligence, data warehousing and data mining.
• Proven ability to work with senior leadership to align business objectives with information technology.
• Experience working with SQL Server, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services) SSMS (SQL Server Management Studio).
• Responsible for Enterprise data warehouse (DW) deployment and integration with source systems.
• Advanced Excel skills including creating and using Pivot Tables, charts, v-look up, graphing and macros.
• Knowledge in design and creation of database and database schema.
• Proficient knowledge of Complex SQL queries using clients like TOAD, SQL Plus and scripts in UNIX.
• Ability to identify a customer’s business needs and articulate how Oracle’s solutions can address those needs
• Experience in Data Modeling techniques employing Data warehousing concepts like star/snowflake schema and Extended Star.
• Experience writing SQL Queries for Data Validation and Data Integration.
• Excellent experience with defining and scoping business areas, eliciting requirements.
• Used SQL queries to extract data from different databases including testing and production for data validation and data analysis.
• Excellent analytical and problem solving skills with ability to interact with various teams for data requirements and mapping to the project database.

TECHNICAL SKILLS

Operating Systems: Microsoft Windows 95/98/2000/XP Pro, UNIX

Databases & Tools: MS SQL Server 2005, 2008, MS Access, Toad, SAS and Oracle 9i,Oracle 10g, MDSS, Teradata

Languages: SQL, Java Script, and VB Script

Internet Technologies: HTML and XML

Software: MS Office Suite, MS Project, MS Visio, and MS SharePoint.

Quality Management: Bugzilla, QuickTest Professional

Methodologies: SDLC, RUP (Rational Rose, Requisite Pro, ClearCase, ClearQuest), Data Modeling, Business Modeling, UML, Use Case Diagrams, Activity and Class Diagrams

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential, San Francisco, CA

Responsibilities:

• Solid experience at writing complex Microsoft SQL Server T-SQL queries and understanding requirements for complex queries and procedures.
• Conduct data analysis using SQL & Excel as part of requirements analysis and to assist data quality teams (SSIS, SSAS, SSMS).
• Prepare extremely detailed ETL design documents and target-source mapping templates based on requirements gathered.
• Excellent Excel skills to work with theclient team in developing scalable and customized business reports.
• Experience with tier-one applications, databases, BI tools and data warehouses, such as Microsoft SQL Server, SSAS, SSIS, SSRS, SSMS., SharePoint and others.
• Serve as Oracle ERP solution delivery expert in the areas of Finance and Supply Chain.
• Work with front office business users and middle office data quality operations team to clarify gaps, gather validation rules and elicit data quality requirements for feed processing & Qlikview data quality dashboard.
• Involved in data mapping of the project requirements, queried the database using SQL queries for data mining, data analysis and data modeling as well as SSIS, SSMS and SSR package.
• Assist with functional migration to the new Oracle ERP systems, data conversion, data cleansing, de-duplication, and data maintenance efforts.
• Responsible for the analysis and design of the data models, data mapping and migration.
• Conduct data analysis using SQL & Excel as part of requirements analysis and to assist data quality teams (SSIS, SSAS).

Environment: Erwin, Oracle, SQL, UML, Rational Requisite Pro, SQL Navigator, MS-Visio, MS Project, MS Office, ETL, Informatica Power Center 8.1

Data Analyst

Confidential | Santa Rosa, CA

Responsibilities:

• Involved in data mapping of the project requirements, queried the database using SQL queries for data mining, data analysis and data modeling as well as SSIS and SSR package.
• Created the Business Requirements Document (BRD) to capture the requirements around monitoring accounts, balances and positions, order status, account reporting, grouping accounts, real-time margin balances and real-time profit / loss.
• Analyzed business requirements and created Use Cases, Sequence diagrams, Activity diagrams using MS Visio as per UML methodology.
• Define technical requirements for the data warehouse (DW) and data marts.
• Reconcile merchant account activity between Oracle ERP system and merchant account.
• Exceptional skills in reporting and dashboard development using reporting tools such as SAP Crystal Reports, SQL Server Reporting Services (SSRS)and SQL Server Management Studio (SSMS).
• Enhanced data structures and converted essential processes into standardized reports for Portfolio Manager
• Worked closely with other project teams such as Portfolio Management and Credit Risk management
• Produced a variety of routine and ad-hoc financial reports, packages for senior management using advanced MS Excel functions

Environment: Oracle9i, MS Visio, MS Project, MS PowerPoint, MS Excel

Market / Data Analyst

Confidential | Raleigh, NC

Responsibilities:

• Involved in gathering data requirements from Sales and Financial organizations to understand the forecasting techniques and practices. Utilized SQL queries for Data Analysis and Data Modeling.
• Proficient in MS SQL Server, SSRS and SSIS, T-SQL.
• Monitor deterioration in data quality of incoming feeds through dashboard and by analyzing feed processing results. Conduct root cause analysis of the errors found in feed processing and report them
• Extracted data from different department to flat files and load the data to the target Oracle and SQL server database.
• Developed new Business Objects reports.
• Data Warehouse (DW) design and tuning to support ETL processes and data analytics applications
• Worked closely with various interfacing development groups such as UI front-end, middleware and backend to communicate the business requirements in a concise way
• Used SQL for querying underlying database tables to analyze the forecasting data and worked with the Data Modelers to create Data model diagrams in working sessions.
• Conducted and participated in Peer Reviews, Walkthroughs and Project Status meetings using MS PowerPoint to communicate project updates to management and project teams

Environment: Business Objects X1 3.1, MS Excel, MS Visio, Dreamweaver, Oracle, MS Access, MS PowerPoint, MS Project

Data Analyst

Confidential | Atlanta, Georgia

Responsibilities:

• Participated in gathering business requirements and analysis of the business processes and identified process improvements.
• Audit the Informatica ETL maps extracting data from the client system, transferring it into a staging area, and then finally, transformed into the reporting SOR.
• Extensively used Informatica tool to extract, transform and load the data from Oracle, Flat Files, to DB2.
• UsedSQL*LOADERto load data into oracle application tables by (control files, data files).
• Extracting data from existing data storesinto applications like Excel and Access, developingand executing departmental reports for performance and response purposes by using oracleSQL procedures, packages, functions, database triggers.
• Created tables, indexes, views, snap shots, database links to see the information extracted from SQL Designed & developed various ad hoc reports for the finance (Oracle SQL,MS ACCESS).
• Developed ETL process to import the data from existing manual MS Access database into the Oracle database for use by the new system.
• Developed ad-hoc reports using SQL in SQL Server 2008 for business users.
• Analyzed business requirements and created Use Cases, Sequence diagrams, Activity diagrams using MS Visio as per UML methodology

Environment: MS SQL Server 2008, MS Excel, Oracle 9i, MS Visio, MS Project, MS PowerPoint, TOAD, Informatica