SUMMARY

• 7+ years of professional experience in business analysis, data modeling, designing, and data analysis
• Proficient in gathering business requirements and handling requirements management
• Designed the ETL system for populating the Datawarehouse from the operational DBMS
• Experience in the Data Warehousing, Data Analysis, Data Mining, Data Mapping, Data Quality, and Data Profiling.
• Experience using different Teradata ETL utilities such as TPump, FastLoad, MultiLoad, FastExport and BTEQ to import/export data across all platforms and also to create and format reports.
• Proficiency in using SET operators, aggregate functions, OLAP functions, inner and outer joins, indexes, etc.
• Experience in performing Data Profiling using Informatica Developer and Informatica Analyst.
• Experience on writing, testing and implementation of SQL triggers, stored procedures, and functions using PL/SQL in Oracle 11g/10g/9i.
• Experience on writing, testing and implementing of SQL queries using advance Analytical Functions.
• Experience on managing data held in RDBMS by writing, testing and implementing SQL queries.
• Experience on developing UNIX Shell Scripts to automate the tasks.
• Extensive experience using advanced SQL coding in Teradata, MS SQL Server, Oracle, My SQL and DB2.
• Workedextensively inData consolidationandharmonization
• Experiencein Data alignmentandDatacleansing
• Strong knowledge of Data Integration, validation and processing methodologies.
• Vast experience of working in the areadata managementincludingdata analysis, gap analysisanddata mapping.
• Well experience in using Teradata Sql Assistant and Toad Sql.
• Worked extensively withDimensional Modeling and Data Migration.
• Experience in Extraction, Transformation and Loading (ETL) processes on Teradata using BASE SAS
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects, Cognos Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Extensiveexperience inData Analysis and ETL Techniquesfor loading high volumes of data and smooth structural flow of the data.
• Adept at writingData MappingDocuments, Data Transformation Rulesandmaintaining Data DictionaryandInterface requirements documents.
• Data Catalog and KPI), Collaboration, Enterprise Content Management (ECM - Document, Record & Web), and Share Point Designer (look and feel).
• Worked on integration and implementation of projects and products,database creations,modeling,calculation of object sizes,table spacesanddatabase sizes.
• Excellent in business process identification and re-engineering business processes.
• Experience withcreating reports using Business Objects and Cognos.
• Strong Knowledge of Business Intelligence, Data Warehousing and Business Architecture.
• Experience in areas of Information Management - Data Analysis, Data Modeling, Data Mapping, Data Warehousing, Data Integration and Metadata.
• Created and executedTest Plan, Test Scripts, andTest Casesbased on Design document and User Requirement document for testing purposes.
• Extensive experience in the testing environment, which includedUser Acceptance Testing (UAT),functional testingandsystem testinganddefect tracking usingClearQuest.

TECHNICAL SKILLS

Databases: Teradata 12/13, MS SQL Server 2005/2008/2012, Oracle 9i, 10g, 11g, My SQL 5.2, DB2

Querying Tools: Quest TOAD 9.1, SQL Server Management Studio 2008/2012, Teradata SQL Assistant, SQL Developer, Teradata-BTEQ, Teradata FastLoad, Terdata multiload, Teradata TPUMP

Predictive Modeling: SAS Base, SAS Enterprise Guide, SAS Enterprise Minder, Minitab

Statistics: SAS (Base Certificate), R, Minitab and Advanced MS Excel Manipulation, Macros in VBA

Data Mining: Weka, SAS Enterprise Miner

Optimization: MATLAB, CPLEX, LINGO, MS Excel

Programming: Java, C/C++. VBA, SQL, HTML, JavaScript

Operating System: Win XP, Vista, 7, Window Server 2003, 2008 (X32, X64), UNIX

Reports: Macros in VBA & Excel, Crystal Reports & SAS, Cognos

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Business SQL Analyst/System Analyst

Responsibilities:

• Collaborated with business analysts/subject matter experts to identify, understand and document requirements.
• Resolved the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources
• Performed detailed data analysis and understood existing architecture and data flows.
• Provided detailed business and data requirements including complex data mappings.
• Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects and Cognos reports.
• Developed BTEQ scripts and Performed Data Analysis & Data Quality Checking.
• Excellent in business process identification and re-engineering business processes.
• Participated in Production Support and troubleshooting data quality and integrity issues.
• Created an automated daily ETL (Extract, Transform& Load) process using Teradata Utilities such as FastLoad, MultiLoad and SQL Assistant (Queryman).
• Maintained and improved the GUI interface of the Data Control Department Database in DB2, MS Access/SQL for all reports and superusers within the company.
• Responsible for balancing reports with previous runs of the report and disbursed all company’s reports on a daily basis. Interfaced and resolved print report issues with department heads.
• Provide Key Performance Indicators (KPI’s) and Annual Forecasted Savings
• Supported OLAP(Online Analytical Processing) by data analysis and SQL execution.
• Conducted statistical analysis and summarized reports and pivot tables using Macros in VBA & Excel.
• Extensively conducted SAS functions such as Proc Report, Proc Tabulate, Proc Summary and Proc Print.
• Obtained good analytical and documentation skills and ability to perform as in a team environment.

Environment: Teradata utilities (FastLoad, MultiLoad, Queryman), DB2, MS Access, OLAP, ETL, SAS, UNIX, SQL, MS Excel

Confidential, Cincinnati, OH

System Analyst/Business Data Analyst

Responsibilities:

• Identified internal and external system requirements, design and configuration set-up.
• Functioned as the liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
• Participated in requirement gathering and identifying business needs for data migration & Data Warehouse.
• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope. Assisted the PM in developing Use Cases and project plans and also managed changes to the scope of the project.
• Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Worked onETL designfor various source systems.
• Reviewed all the systems design by assuring adherence to defined requirements.
• Conducted business-impact assessment and the results were compared with the new HIPAA 5010 standards to determine the current level of compliance and developed an action plan for approval by the project steering committee
• Created the conceptual, Logical and Physical Model for the data warehouse with emphasis mutual funds and annuity using Erwin data modeling tool.
• Created numerous SQL Queries to Load and Set, Multi Set and Volatile tables using Teradata.
• Extracted data to and from Database using Teradata, MS SQL, DB2 as well as OLAP Functions for Data Cleansing & Scrubbin
• Performed numerous SQL queries using DDLs, DMLs along with various Aggregate functions to perform OLAP/OLTP.
• Provide Key Performance Indicators (KPI’s) and Annual Forecasted Savings
• Implemented changes and analyzed data on existing modules, creating new modules by writing SQL Queries.
• Worked closely with Team members and End Users to come up with best scenarios to improve Business Process.
• Experience in writing and implementing FTP, archive and purge Scripts in UNIX.
• Collaborated with developers to make sure that they understood the Use Cases.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Cooperated with Quality Control Teams to develop Test Plan and Test Cases.

Environment: Microsoft Office, MS Visio, Windows XP, SQL, Teradata, DB2, VB, J2EE, ASP, Crystal Reports

Confidential, Jersey City, NJ

System Analyst/Business Data Analyst

Responsibilities:

• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Understand end to end supply chain SCM implementation.
• Analyzed the given source Dimensions and target Fact table structures to develop Surrogate Key tables referencing required dimensions.
• Performing Adhoc reports using Oracle, Teradata, Bteq, and UNIX
• Worked extensively with many of the external vendors such as Northern Trust Bank, Plan Data Management (PDM), and Mellon Bank as a point of contact from the client’s side.
• Worked extensively with Vendors like PDM on crosswalks for various file formats.
• Generated flat files using the Teradata Export for the Segmentation process
• Conducted GAP Analysis in understanding how the upgraded system carries out the business functions and assists in ensuring the timely and effective completion.
• Conducted feasibility study and performed impact analysis for proposed enhancements.
• Identified, investigated, analyzed, defined and documented business processes and their Critical success factors.
• Ability to interact with developers and product analysts regarding testing status and defect tracking.
• Experience in Problem solving and Defect Tracking Reports using defect tracking Tools like Quality Center, Test Director and Clear Quest
• Wrote SQL queries for multiple scenarios
• Involved in creating project schedules, milestone tracking and resource allocation using MS Project. Developed timelines for project delivery and managed projects and resources to successful completion.
• Coordinated and liaised with the QA and testing teams for bug and defect tracking, created test cases and assisted with test plans time to time.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Intensively worked on integrating KPI’s and Excel Reports upon Dashboard pages.
• Manually performed UAT by writing numerous SQL test cases and executing them to validate the results .
• Worked in Cost Basis Group, who deals with taxes, shares all other financial records of client companies.
• Organized meetings on a regular basis with various stakeholders in order to identify various requirements.
• Conducted JAD sessions for multiple projects and played the role of a Facilitator in multiple JAD Sessions.
• Worked with SCM tools like cvs, clearcase, subversion, starteam and good exposure to build tools such as Maven.
• Developed & executed several Optimized queries in SQL on this data.
• Tested Performance & Accuracy related queries under SQL Server.
• Used SQL to validate data stored and retrieved in the database.

Environment: MS Office, SQL, Teradata, Oracle, Pl/sql, SCM (Supply Chain Management), UML, MS Project, MS SharePoint, Rational Requisite Pro and MS Access.

Confidential, Williston, VT

Business Analyst

Responsibilities:

• Understand business requirements and develop database models accordingly.
• Coordinated and liaised with the QA and testing teams for bug and defect tracking, created test cases and assisted with test plans time to time.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object oriented Design) using UML and Visio.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Manually performed UAT by writing numerous SQL test cases and executing them to validate the results .
• Maintained technical documentations for reference purposes.
• Worked on BSS/OSS products to help customer to place orders, process bill, manage the inventory and record the payments.
• Created schemas, set, multi set and volatile tables.
• Created stored procedures, functions, views, triggers, etc.
• Implemented protection features and collected statistics to comply with the coding standards.
• Analyzed access patterns and implemented the best combination of indexes, constraints, foreign keys, etc.
• Executed queries using multiple aggregate and OLAP/OLTP functions and joins.
• Executed numerous highly tuned SQL statements like Explain, Statistics, Cast and Format.
• Performed numerous data extraction requests using SQL scripts to prepare ad hoc reports.
• Created numerous SQL queries to load and extract data to and from database using MSSQL/Oracle/Teradata/DB2.
• Extensively worked on data extraction, transformation and loading from source to target systems for bulk import and bulk export using bcp utility, BULK INSERT or OPENROWSET(BULK) statements on MSSQL platform.
• Used Informatica for importing metadata from repository and creating new data elements.
• Responsible for data quality checking, segmentation, modeling and analysis.
• Collaborated with database administrators and application developers to troubleshoot performance problems and propose short/long term solutions.
• Daily interaction with internal users and business analysts for updates and proactive data sharing to design and develop stakeholder centered Ad hoc reports.
• Executed numerous SQL queries using DDL and DML statements.
• Created SHELL scripts in UNIX.
• Ensure that SDLCs between the application and database development teams are tightly integrated in their process.
• Ensured that data warehouse design were scalable and maintainable.

Environment: MS Office, SQL, Oracle, Pl/sql, SCM (Supply Chain Management), UML, MS Project, MS SharePoint, Rational Requisite Pro and MS Access.