PROFESSIONAL SUMMARY:

• 7+ years’ experiences working in the IT industry specializing in Data analyst, Microsoft SQL Server database and development.
• Experience in designing and developing Data Warehouse applications using ETL and Business Intelligence tools like INFORMATICA Power Center, SSAS, SSIS, Business Objects.
• Excellent understanding of Data ware housing Concepts Normalization/De - Normalization, Dimension Fact tables.
• Experienced T-SQLscripting for creating various database objects like Stored Procedures, Functions, Triggers and Views and complex query writing.
• Experience using query tools for ORACLE, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Experience in developing TERADATA databases, manipulating data and making change to dimensions in databases using TERADATA Utilities
• Utilized control flow items such as ExecuteSQLTask, Execute Package task, File System Task as well asdataflow using Aggregate, Lookup component,Dataconversion in SSIS.
• Expertise in creating and managing Event Handlers, Error Handling, Logging, System and User-defined Variables for SSIS Packages.
• Excellent hand-on experience in managing and automating Control flow,Dataflow.
• Extensively worked on the ETL mappings, source data analysis, source to target mapping and documentation of OLAP reports requirements.
• Understanding of OLTP and OLAP concepts and challenges, especially with large data sets.
• Experience inDataTransformation,DataLoading, Modeling and Performance Tuning.
• Proficiency in creating different types of reports such as Parameterized, Dynamic, Drill-through, Drill-down reports, Sub reports and formatting them using SSRS.
• Performed Data Analysis, Data Migration and data profiling using complex SQL on various sources systems including ORACLE and TERADATA.
• Excellent hands on experience in working with Star/Snowflake Schema modeling to develop using SSRS
• Very good understanding of Business Intelligence andDataWarehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• Strong in database design, domain modeling and ER diagrams design
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

TECHNICAL EXPERIENCE:

Databases: MS SQL Server 2012/2008/2005/2000 , ORACLE0.9, MS Access 2007, Teradata.

Reporting: SQL Server 2000/2005 reporting services.

ETL Tools: INFORMATICA 9.0/8.1/7.x/6.x/5.x, Data Stage, SSIS, SSAS

Database Development: T-SQL and PL/SQL, Microsoft Hyper-V Servers

Office Applications: MS Office (Word, Excel, Visio, PowerPoint, Project)

Web Development: HTML, XML and FrontPage, Visual Basic 6.0

Operating Systems: Windows 7/Vista/2000/XP/2003, Unix 5.2/4.3

PROFESSIONAL EXPERINCE:

Confidential, Richmode, VA

SR. DataAnalyst

Responsibilities:

• Translated business needs intodataanalysis, business intelligencedatasources and reporting solution for different types of Clients.
• Involved in migration of various objects like stored procedures, tables, and views from various data source to SQLServer.
• Created various weekly and monthly portfolio reports showing detailed information by usingSQL Server Constraints in writing TransactSQL(T-SQL) queries and Dynamic-queries.
• Data modeling, Design, implements, and deploy high-performance, custom applications at scale on Spark.
• Created variousSQLSchema, Triggers, views, index/keys and stored procedures along with compiling them inSQLserver and troubleshoot errors.
• Used complex query statements like, sub queries, correlated queries, derived tables, CASE functions to insert thedatadepending.
• Creating Test case & Test scripts by Agile Methodology.
• Optimized DB2 SQL by reducing the number of table reads as part of performance tuning.
• Performed extensive Data Integrity testing by executingSQLStatements on ORACLE & SQL database.
• Created ETL packages with differentdatasources (SQLServer, Flat Files, Excel source files, XML files etc.) and then loaded thedatainto destination tables by performing transformations.
• Created SSRS Report Model Projects in MSBI studio and created, modified and managed various.
• Generated Complex reports like reports using Snapshot reports Drill- down Reports, Drill-Through Reports, Parameterized Reports.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse.
• Extensively worked with the TERADATA SQL assistant for testing and analyzing the data
• Conducted performance tuning of complexSQLqueries and stored procedures by usingSQLProfiler and index tuning wizard.
• Maintaining the DB2 database environments and troubleshooting performance problems.
• Used Database Mirroring for increasing database availability.
• Created and implemented best backup and recovery strategies.
• Used UNIX scripts to access TERADATA & Netezza Data and developed UNIX for data manipulation.
• Develop Mapping ofdatalineage for each attribute stored in differentdatawarehouses and across several source systems.
• Testing and migration of SSIS workflows and mappings from one Repository to another Repository.
• Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
• Establish documentation for Agile methodology for implementation with a very water-fall- centric development team.
• Analyzed the data from SQL server and ORACLE to load TERADATA.
• Implementeddataaccess, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Responsibilities include gathering business requirements, developing strategy fordatacleansing anddatamigration, writing functional and technical specifications.

Environment: SSRS, SQL Server, Flat Files, XML, T-SQL, SSIS, Agile, PL/SQL, DB2, TERADATA, ORACLE, Unix

Confidential, New York City, NY

Data Analyst

Responsibilities:

• Gathered requirements and created ER (entity-relationship) diagrams as part of requirements analysis usingErwin.
• Worked with business requirements analysts/subject matter experts to identify and understand requirements.
• Defined key facts and dimensions necessary to support the business requirements along with Data Modeler.
• Created draft data models for understanding and to help Data Modeler.
• Resolved the data related issues such as assessing data quality, data consolidation, evaluating existing data sources.
• Manipulating, cleansing processing data using Excel, Access and SQL.
• Logical and physical Modeling for OLAP and OLTP systems.
• Involved in full life cycleBusinessObjectsimplementation.
• Extensively worked on the ETL mappings, source data analysis, source to target mapping and documentation of OLAP reports requirements.
• Implementing business-driven requirements using INFORMATICA and TERADATA utilities.
• Created dimensional model for the reporting system by identifying required dimensions and facts usingErwin.
• Worked on to convert ORACLE scripts into TERADATA scripts
• Preparing Dashboards using calculations, parameters inTableau.
• Involved in creating Dashboards, reports, as needed using TableauDesktop and TableauServer.
• Performed Data Validations using SQL developer.
• Used SQL for Querying the DB2 database in UNIX environment.
• Involved in installingBusinessObjects, creating Repository, Users, and User Groups and prioritizing Security Levels for Users and User Groups.
• Involved in developing an ETL strategy to populate the Data Warehouse from various source systems feeds using INFORMATICA Power Center and TERADATA.
• Responsible for loading, extracting and validation of client data.
• Analyzed the source data coming from various data sources like ORACLE.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables.
• Developing Data Modeling and analyzing existing TERADATA SQL and load processes,
• Tested the data using the Logs generated after loading the data in to Data warehouse.
• Prepared Traceability Matrix with requirements versus test cases.
• Involved working on different set of layers of Business Intelligence Infrastructure.
• Worked extensively on the T-SQL environment to run out the queries and explore the Databases.
• Worked with OLAP tools such as ETL, Data warehousing and Modeling.
• Researched client’sbusinessissues and goals to offer appropriate solutions.
• Extractdatafrom ORACLE database toTERADATAto be used as operationaldata.
• Used INFORMATICA to extract, transform data from SQL Server to ORACLE databases.
• Meeting with user groups to analyze requirements and proposed changes in design and specifications.
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data.

Environment: INFORMATICA, Business Objects, ORACLE 11g, T-SQL, DB2, SQL Server, Erwin, PL/SQL, MS Excel, MS Access. TERADATA, OLAP, OLTP, UNIX

Confidential, Cleveland, OH

DataAnalyst

Responsibilities:

• Involved inDatamapping specifications to create and execute detailed system test plans.
• Thedata mapping specifies datawill be extracted from an internaldatawarehouse, transformed and sent to an external entity.
• Analyzed business requirements, system requirements,datamapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, ORACLE and TERADATA Databases.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to loaddatafrom source flat files and RDBMS tables to target tables.
• UsedINFORMATICAdebugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Responsible for differentDatamapping activities from Source systems to EDW, ODS datamarts.
• Created the test environment for Staging area, loading the Staging area withdatafrom multiple sources.
• RelationalData(ORACLE, DB2 MS SQL Server) from variousdatasources.
• Resolve the batch monitoring related issues with respect topurchasingmodule.
• Involved in testing the XML files and checked whetherdatais parsed and loaded to staging tables.
• Responsible for creating test cases to make sure thedataoriginating from source is making into target properly in the right format.
• CreatedINFORMATICAmappings with PL/SQL procedures/functions to build business rules to load data.
• Tested several stored procedures and wrote complex SQL syntax using case, having, connect by etc
• Involved in TERADATA SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
• Tested the messages published by ETL tool anddataloaded into various databases
• Involved in creating UNIX scripts for file transfer and file manipulation.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: INFORMATICA, ORACLE, Quality Center, SQL, T-SQL, DB2, PL/SQL, Flat Files, TERADATA, UNIX, XML Files, Windows.

Confidential, Chicago, IL

DataAnalyst

Responsibilities:

• Gathering the requirements by interacting heavily with the business users, multiple technical teams to design develop the work flows for the new functional piece.
• Responsible for installation ofSQLServer, database design, and create schema objects like tables, views and indexes
• Extensively used joins and sub queries for complex queries involving multiple tables from different databases.
• Design and implementation of Time Series feature for TERADATA Database
• Designed and Developed ORACLE PL/SQL.
• Define and build best practices regarding creating business rules within the INFORMATICA.
• Performance tuning of stored procedures and functions to optimize the query for better performance.
• Transformed complex business logic into database design and maintaining it by usingSQLobjects, stored procedures, user defined functions, views, T-SQLscripting and jobs.
• Working with DifferentTERADATAsource systems to analyzedataand load it into theDatawarehouse.
• Involved in Designing the DB2 process to Extract translates and load data from OLTP ORACLE.
• Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided using SSRS.
• Created various SSRS reports such as Multi-valued reports, Parameterized, Linked reports, Drill down reports, Tabular Matrix reports and Chart diagrams.
• Scheduled SSRS reports for end users and managed the security of the reports.
• Exported SSRS reports to various formats like PDF, Word and Excel and scheduled to reports to send as an email body.
• Strong analytical and problem solving skills coupled with interpersonal and leadership skills.
• Interaction with the clients to gather out the requirements and assist them in immediate workarounds for the issues with the application.

Environment: SSRS, ORACLE, DB2, INFORMATICA, T-SQL, SQL, PL/SQL, OLTP, XML Files TERADATA, UNIX, Windows.

Confidential

Data Analyst

Responsibilities:

• Studied and understood the requirements of the information required by company Procurement Department about the vendors
• Wrote and Debugged T-SQL, stored procedures, Views and User Defined Functions
• Developed database objects like Tables, views, stored procedures, indexes etc.
• Worked with fellow developers in rewriting procedures, functions, triggers, table partitions, views for better functionality.
• Design and implementation of Time Series feature for TERADATA Database.
• Wrote T-SQL queries for the retrieval of the data
• Worked with the developing team in the Writing functions in Visual Basic for Upload download functionality, Data transfer and migration
• Worked with developers on how to write better SQL, how to use more powerful features like table variables, how to avoid cursors, etc.
• Performed Data Analysis, Data Migration and data profiling using complex SQL on various sources systems including ORACLE and TERADATA.
• Responsible for Data Design creation of symmetry table load files, build the jobs in INFORMATICA and unit test the jobs.
• Sequence container and Execute SQL task etc.
• Created and executed the stored procedures and complex queries for reports.
• Developed tasks of SQL Server of performing daily Backups and Recovery procedures

Environment: INFORMATICA, SQL Server, T-SQL, ORACLE, TERADATA, UNIX, Windows.