SUMMARY:

• 6+ years of experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2000/ 2005/2008/2008 R2/2012 in Development, Test and Production Environments in financial, healthcare, retail and telecommunication domains.
• Handled modeling changes to legacy and future databases, using PowerDesigner and implemented them on Development and Test databases and moved the same to Production Instances during the production release.
• Documented using the Metadata Repository (MDR) and the business rule spreadsheet (BRS) from the Corporate Data Warehouse (CDW) and the Integrated Operational Data Store (IODS) for financially reported Critical Data Elements (CDEs).
• Experienced to develop a customized mortgage accounts management solution to provide home mortgages, home refinancing, and home equity loans to consumers
• Expert in working with Data Modeling tools including ERwin Data Modeler and Sybase PowerDesigner.
• Expertise in Logical Modeling, Physical Modeling, Dimensional Modeling, Star and Snow - Flake schema.
• Developed Data Migration and Cleansing rules for Integration Architecture (OLTP, ODS, DW)
• Extensive success in translating Business Requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
• Strong business analysis skills and an understanding of the software development life cycle (SDLC) utilizing Rational Unified Process (RUP).
• Experience in designing/developing SQL statements and queries for Oracle, Teradata and SQL Server 2005/2008/2008 R2/2012 databases for Data profiling, MDM and development.
• Experience in writing/optimizing SQL queries in Oracle and SQL Server 2005/2008.
• Skilled at conducting Requirement Analysis, use case design, test plans design and database schemas Development based on the logical models.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill Down, Drill Through, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Generated ad hoc Tableau reports with trend lines on demand for providers.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Extensively used VLOOKUP, COUNTIF, COUNTIFS, CONCATENATE, IF functions and created Pivot Tables in Microsoft Excel to analyze the data.
• Hands on experience in Creating Star Schema and Snow Flake Schemas
• Full understanding of RAD, Waterfall, RUP and Agile methodologies.
• Experienced in design/development of Data Warehouse applications using ETL and Business Intelligence tools like Informatica Power Center (9.5.1/8.1/7. x/6.x/5.x) /Power Mart 4.7, DataStage, Mainframes, SAS, SSAS, SSIS, OLTP, OLAP and Business Objects.
• Facilitated/participated in Joint Application Development (JAD) sessions, and white board sessions with SMEs to keep executive staff and team members apprised of goals, project status, and issue resolution.

TECHNICAL SKILLS:

Operating Systems: Windows 2008/2003/2000/ NT, LINUX, UNIX.

Languages: SQL, PL/SQL, T SQL, Teradata, HTML

Databases/software: Oracle 10g/9i/8i, SQL Server 2012/2008R 2/2008/2005/2000, DB2, UDB, Teradata, MySQL, MS Access, VB Macros, MS Office, SharePoint, MS Excel

Rational Tools: Rational Rose, Rational RequisitePro, Rational ClearQuest, Rational ClearCase and SoDA

ETL Tools: Ab Initio, Informatica 8.1/7.x/6.x/5.x., Data Stage, SAS, SSIS, SSAS

Data modeling tools: Sybase PowerDesigner, CA Erwin, MS Visio

Reporting tools: SSRS, Crystal Reports, and Business Objects

Methodologies: UML, RUP, Ralph Kimball’s Dimensional Data Mart modeling

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Data Analyst/ SQL Developer

Responsibilities:

• Involved in the projects from requirement analysis to better understand the requirements and support the development team with the better understanding of the data related to origination, lien, and default.
• Initiated and conducted JAD sessions inviting various teams to finalize the required data fields and their format.
• Worked as a developer in creating Stored Procedures, triggers, function, tables, and otherSQLjoins and statements for applications.
• Wrote complex Teradata SQL queries to pull the metrics for CTQ’s, in order to ensure that the process is within agreed tolerance limit.
• Created reports to retrieve data using database code objects, such as Stored Procedures, views, functions and multiple T-SQLqueries.
• Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics.
• Developed data access queries/programs usingSQLQuery to run in production on a regular basis.
• Created report snapshots to improve the performance of SSRS.
• Created report models for ad hoc reports when the end user wants to see the reports on the fly.
• Created and Managed OLAP Cubes using SSAS. working withSSASin creatingcubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Responsible for Monitoring and Tuning Report performance by analyzing the execution plan of the report.
• Assist with gathering the reporting requirements for both Business Intelligence and Crystal reports.
• Designed and developed existing reports using Crystal Reports.
• Prepared management reports relating to data cleansing and classification tasks.
• Worked extensively in creating the DMR Mapping Spreadsheets, Source to Target Mapping documents.
• Analyzed the transformation rules and Joins/Filter logic documents.
• Worked as a member of the Data lineage Team in the Enterprise Data Program division to create the Data Functional Design Documents.
• Reverse Engineered databases to understand the relationship between already existing tables.
• Created an initial data model (conceptual) to in corporate the new data elements for new functionality.
• Created Logical/Physical data models from the conceptual model identifying the cardinality between the tables.
• Prepared the Joins/Filter logic documents that would help the ETL design team perform the Joins on the tables that are in the form of flat files before loading them to FDS or any downstream systems.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.
• Worked on integration workflows and load processes and Data consolidation.
• Generated DDL scripts for the developed physical model.
• Created Source to target Mapping Matrix in loading the data to Dimensions and Fact Tables.
• Worked with data modelers to handle the modeling changes to legacy and future databases, and implementing them on Development and test databases and moving the same to Production Instances during the production release.
• Created use case scenarios to test performance of the Finance Data Store.
• Developed MDM strategies and solutions utilizing SQL server MDS tools.
• Worked with the CCG (Consumer and Credit group) team to develop a star schema for the CCG - Collections Data Mart identifying the Fact and Dimension tables.
• Involved in Semantic layer design. Building views based on requirements given by users.

Environment: Oracle, SQL Server 2008 R2/2012, Windows 2008, OLAP, VB.NET, Teradata, Microsoft Access, Microsoft Visio, Microsoft Excel, Remedy.

Confidential, Birmingham, AL

Data Analyst/SQL Developer/BI Developer

Responsibilities:

• Developed DML scripts to Insert, Update and Delete data in MSSQL database tables with SQL Server Management Studio.
• Created Views to facilitate easy user interface on database tables, and created Triggers to facilitate consistent data entry into the database tables.
• Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
• Performance Tuning of T-SQL Statements implemented effectively with SQL Profiler and Database Tuning Advisor.
• Obtaining, organizing, defining subject area Meta Data in applicable repositories (Teradata, SQL Server, Oracle).
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages and VBScript.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
• Implemented Transactions is SSIS Packages using Sequence containers and Execute SQL tasks.
• Improved the performance of SSIS packages by implementing parallel execution, removing unnecessary queries and sorting to use optimized queries.
• Designed and created Report templates with Constant Header information like Company logo, Department Name etc. for Weekly, Monthly reports.
• Developed various management information reports by using crystal reports 2008.
• Converted the weekly, bi-weekly, monthly and quarterly reports from ad-hoc database to new data warehouse using SAS.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Analyzing datasets and generating statistical reports using SAS
• SQL and Macros with better and accurate values.
• Designed and implemented a variety of SSRS reports such as Parameterized, Drilldown, Ad-hoc and Sub-Reports using Report Designer and Report Builder based on the business requirements.
• Designed Charts with lines, Bar Graphs and Columns to generate reports with cumulative totals.
• Involved in Trouble shooting and Performance improvement of SSRS Reports.
• Integrating SSRS reports into various Web applications using Web Service and Report Viewer Control in .NET framework 2.0.
• Deployed various reports onto Report Server and Report Manager in SSRS 2008 R2.

Environment: SQL Server 2008 R2, Management Studio, Business Intelligence Development Studio (SSIS, SSRS), SAS, Teradata, MS-Visual Studio, Power Designer, MS Excel.

Confidential, Franklin, TN

SQL Analyst/Data Analyst

Responsibilities:

• Involved as Developer for Commercial Business Group data Ware House (CBGDWH).
• Development of source Data profiling and analysis - review of data content and metadata will facilitate data mapping, and validate assumptions that were made in the business requirements.
• Create Logical and Physical Design of Database and ER Diagrams for relational and dimensional database using Erwin.
• Extracted data from relational databases Oracle, and Flat Files.
• Developed Complex transformations, Mapplets using Informatica Power Center 8.6.1 to Extract, Transform and load data into Operational Data Store (ODS).
• Designed complex mappings using Source Qualifier, Joiners, Lookups (Connected & Unconnected), and Expression, Filters, Router, Aggregator, Sorter, Update Strategy, Stored procedure and Normalizer transformations.
• Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
• Performed Data alignment and Data cleansing.
• Performed Data Validations using Microsoft SQL Server Management Studio 2005.
• Worked closely with Business Analyst, and DBA team.
• Preparation of test cases/scenarios and execution.
• Used debugger to test the mapping and fixed the bugs.
• Created sessions, sequential and concurrent sessions for proper execution of mappings in workflow manager.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.
• Used USPS Address Mapping System for correcting the Customer Address.
• Wide usage of Lookup Files while getting data from multiple sources and size of the data is limited with Data Mapping.
• Involved in System Integration Testing (SIT) and User Acceptance Testing (UAT).
• Developed standard, advanced, graphical and cross-tab, on demand and Drill-down reports using Crystal Report and SSRS.
• Provided SSRS and SSAS support for internal IT projects requiring report development.

Environment: Informatica 8.6.1, Oracle, SQL Server 2005/2008, RDBMS, Fast load, FTP, SFTP, Business Objects Universe.

Confidential, Grapevine, TX

SQL Data Analyst

Responsibilities:

• Involved in requirement gathering along with the Business Analysts Group.
• Involved in Object Modeling in UML using Rational Rose 2000
• Gathered all Sales Analysis report prototypes from business analysts belonging to different Business units
• Gathered various requirement matrices from the business analysts
• Participated in Joint Application Development (JAD) sessions
• Conducted Design discussions and meetings to come out with the appropriate Data Mart designed for the various reporting requirements
• Conducted Design reviews with the business analysts, content developers and DBAs.
• Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts, Inventory data marts using Erwin with various Dimensions (Time, Services, Customers, Sales Hierarchy, Orders, Snow flake Dimensions and FACT Tables)
• Designed Sales Hierarchy dimensions to handle sales hierarchy reporting historically and dynamically.
• Coordinated with corporate Enterprise Data Warehouse (EDW) effort for impact of conceptual enterprise data model (EDM) to production LDMs.
• Developed Data Migration and Cleansing rules for Integration Architecture (OLTP, ODS, DW)
• Developed data mapping documents between Legacy, Production, and User Interface Systems
• Worked with the Implementation team to ensure a smooth transition from design to implementation phase.
• Performed Data Loading and Transformation using SQL* Loader.

Environment: SQL Server 2005, Windows NT, ERWin 4.0, MS-DTS, SQL*Loader, Data Junction, Rational Rose 2005