SUMMARY

• Over 9 years of total experience in information technology, software programming and development, Application integration, Migration & Conversion, Requirement gathering plus Development and End Client Communication.
• Experience in developing a requirement design document, test scripts as well as migration scripts during the life cycle of a project.
• Strong understanding of Data Modeling in data warehouse & OLTP environments such as star schema and snow flake schema & 3NF data models
• Experienced in development of ETL mapping and scripts.
• Excellent understanding of Business/Market Intelligence, Business Process Modeling, Re - Engineering, databases,DataWarehousing, data mapping, data modeling, data migration, data integration & ETL process
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering,
• Dimensional Data modeling, FACT& dimensions tables, physical & logical data modeling.
• Experience in Client Server and Web applications using SQL, PL/SQL, PERL, and Shell Scripts and relational databases like Oracle, Teradata, Netezza, NoSQL, UNIX and Windows platforms.
• Proficient in SQL queries on Oracle, Teradata, Netezza & SQL Server databases
• Extensive involvement in development and Performance tuning of SQL and PL/SQL using HINTS like CHOOSE, RULE, FIRST ROW, ALL ROWS, INDEX and PARALLEL QUERY and plan table, TKPROF and implementation of Table Partitioning.
• Exposure to Oracle Temporary tables and collections, Experience in Optimization of queries in PL*SQL.
• Strong understanding of KPI's, data relationships, reporting schemas, data transformations
• Solid Experience in data analysis and problem solving with large amounts of data
• Solid Experience in data architecture, data warehousing, master data management, enterprise information integration and ETL.
• Proficiency with various tools like Control-M, Cron Jobs, Autosys, oracle Job Scheduler for Job Scheduling.
• Exposure to the Data Warehouse Model and concepts like Star, Snowflake Schemas, ODS, EDW, Data marts and Staging area.
• Solid experience with Data profiling & creating data mapping documents by building a great relationship with the business users
• Interpret and convert business requirements into IT functional specs Technical requirement Docs.
• Exposure to reviewing and creating documentation for Modules / Projects.
• Extensive knowledge working on ERWin data modeler & Power Exchange for data modeling.
• Successfully handled complex projects with rapidly evolving requirements.
• Effective communication skills and record for coordination between globally located teams.
• Exceptional ability to maintain and build client relationships, frequent travel meeting one on one with clients, able to comfortably converse with all facets in the clients organization.
• Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
• Experience in gathering business and technical requirements that would best suit the needs of the technical architectural development process
• Experience in developing accurate business process requirements.

TECHNICAL SKILLS

Technology: Oracle PL*SQL, VB 6.0, ASP, SQL Server 2000, C, C++, Unix

Hardware / Platforms: Windows … Unix, MS- Dos

Databases: Oracle, SQL Server, Teradata, Netezza, Cassandra, MongoDB

Scripting Languages: JavaScript, HTML, Perl, Shell.

Version Control Systems: MS Visual Source Safe (VSS), SVN

Reporting Tools: COGNOS Reports, Crystal reports, Excel reports.

Job Scheduling: CronTab Job, Control-M, Autosys, oracle Job Scheduler.

Tools: Informatica Power Centre, DataStage, Talend, TOAD, SQL * Plus, Secured CRT, Edit plus, Text pad, ERWin, Aginity

PROFESSIONAL EXPERIENCE

Confidential, Mason, OH

Sr. Data Analyst

Responsibilities:

• Provided informatics, quality, and business value assessments across a series of applications, tools, and associated monitoring systems.
• Participated in the development and documentation of supporting infrastructure, metrics development, process improvement, and life cycle development.
• Working as data modeler & involved in building high quality enterprise level conceptual, logical, and physical data models
• Gather and document requirements, provided via internal or external stakeholders, to code and implement stored procedures and audits, using SQL Advantage or ASE ISQL, to insert into or update client records within the database management system.
• Worked on Information Analyzer to profile the data and provided various reports.
• Responsible for directing all aspects ofdatamanagement associated with client requested fee for service projects & implementations as well as internally driven initiatives.
• Worked withdataarchitecture, database design, and affiliated documentation practices to include ERD’s anddatadictionaries.
• Generated and maintained a concise set of standard reports that provide insight as to the performance of the organization, as well as conduct ad-hoc reporting and analysis as necessary.
• Applied technology and business requirements to develop reporting solutions using multiple, complex datasources which may include working with and maintaining several datatables and business rules.
• Evaluated findings, using knowledge of workflow and operating practices.
• Ensured the integrity, accuracy, and validity of the information being reported and understands the content of supporting documentation.
• Collaborated with cross functional groups and communicate project status across the organization.
• Supported strategic procurement group through managing weekly and monthly reports, as well as regularly updating item master database.
• Worked with internal architects and, assisting in the development of current and target state enterprise dataarchitectures.

Environment: SQLServer, MS Office 2007, MS Visio 2003, MS Excel, SharePoint, PowerPoint, MS Project, MS Outlook

Confidential, St Louis, MO

Data Analyst

Responsibilities:

• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users.
• Wrote the test cases and technical requirements and got them electronically signed off.
• Created new reports based on requirements.
• Utilized simple methods like PowerPoint presentations while conducting walkthroughs with the stakeholders.
• Used complex SQL Queries for validating and verification ofdatastructure. Generated reports using complex joins, sub-queries and aggregate functions
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Involved in defining the source to target data mappings, business rules, business and data definitions.
• Created Report-Models for ad-hoc reporting and analysis.
• Extensively designed data mapping and filtering, consolidation, cleansing, integration, ETL, and customization of data mart.
• Documented various Data Quality mapping document.
• Performed small enhancements (data cleansing/data quality).
• Performed data analysis on the existing data warehouse.
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation.
• Upgraded the present application by adding new functionalities and adding new reports.
• Wrote regression test cases, did smoke testing with users.
• Coordinated (with business users, data base administrator, mainframe team and testing team) in mirror to production testing.
• Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system.

Environment: MS Office 2007, MS Visio 2003, Windows XP, AFS, MS Excel, SharePoint, PowerPoint, MS Project, UML, SQL Server, Erwin, Business Objects, MS Outlook

Confidential, Westchester, PA

Data Analyst

Responsibilities:

• Prepared various reports & semantic layers on Teradata using SQL for all lines of businesses to help the business make decisions and strategies.
• Helped in developing analytical offer reports in Teradata while analyzingdataon daily basis to extract latest information needed for migration purposes.
• Worked on Website Management analytics while identifying new trends for information, search tuning, content management, online chat, and vendor evaluation using Qualtricsdata.
• Work closely with SME (Subject Matter Expert) to identifydataelements that need to be assessed and loaded into Trillium Discovery before analyzing thedata.
• Create business rules in Trillium to find the incorrectdataand compare with source allowed values.
• Research discrepancies and potential issues and work with SMEs to find resolutions.
• Familiar with the quality analysis process, performed gap analysis and did the necessary quality analysis documentation.
• Prepare test cases fordataconversion.
• Perform audit validation and share the result findings with stakeholders anddataassessment core team.
• Perform ad-hoc analysis and provide recommendations to report on various insurance metrics.
• Prepare weekly and monthly DB tracking and validation reports both at corporate and regional level.
• Dataprofiling and assessment done using SAS for large datasets.
• Responsible for ensuring accuracy while inputtingdatainto online web portal as well as providing key documentation for ad hoc reports.
• Communicate critical information to purchasers and planners to verify information, correct errors and request additional documents.
• Maintained database of competitor feedback and product estimates for new and existing customers.

Confidential, Iowa City, IA

Data Analyst / Data Modeler

Responsibilities:

• Used the Agile methodology to build the different phases of Software development life cycle.(SDLC).
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, Logical DataModels using Erwin, documenting and rolling out the deliverables.
• Normalized the database based on the new model developed to put them into the 3NF of the datawarehouse.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Met with users and stakeholders to understand the problem domain, gathered customer requirements through interviews (group and one-on-one) along with JAD sessions.
• Came up with methods to reduce risks of releasing new upgrade to the system in production by doing a controlled of new features (upgrades).Conducted analysis and profiling of potential datasources, upon high level determination of sources during initial scoping by the project team.
• Coordinateddataprofiling/datamapping with business subject matter experts, datastewards,data architects & ETL developers.
• Coordinated with onsite and offshore teams for better understanding of client needs and provided quality deliverables.
• Manually generated reconciliation reports using MS Excel and Access.
• Developed, reviewed, understood and validated Testing scenarios/scripts, Defect Tracking with Clear Quest, Configuration Management with Clear Case.
• Excellent knowledge in Software Quality Assurance (SQA), effective software quality control and in developing test cases, test plans, test scripts, tests strategies in HP Quality Center with effective Content Management skills.
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application

Environment: Oracle, SQL Server, Erwin 8.1, Windows XP, XML, Excel, Quality Center, MS Office, MS Project, SharePoint, MS Visio

Confidential, Gainesville, FL

Data Analyst / Data Modeler

Responsibilities:

• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, Logical DataModels using Erwin, documenting and rolling out the deliverables.
• Normalized the database based on the new model developed to put them into the 3NF of the datawarehouse.
• Involved in dimensional modeling, identifying the Facts and Dimensions.
• Came up with methods to reduce risks of releasing new upgrade to the system in production by doing a controlled of new features (upgrades).
• Conducted analysis and profiling of potentialdatasources, upon high level determination of sources during initial scoping by the project team.
• Coordinateddataprofiling/datamapping with business subject matter experts, data stewards, data architects, ETL developers.
• Coordinated with onsite and offshore teams for better understanding of client needs and provided quality deliverables.
• Manually generated reconciliation reports using MS Excel and Access.
• Developed, reviewed, understood and validated Testing scenarios/scripts, Defect Tracking with Clear Quest, Configuration Management with Clear Case.

Environment: Oracle, SQL Server, Erwin 8.1, Windows XP, XML, Excel, Quality Center, MS Office, MS Project, SharePoint, MS Visio.