SUMMARY

• Over 9+ years of extensive Information Technology experience in all phases of Software development life cycle including System Analysis, Design, Data Modeling, Dimensional Modeling, implementation and Support of various applications in OLTP and Data Warehousing.
• Data Modeler with strong Conceptual, Logical and Physical Data Modeling skills, Data Profiling skills, Maintaining Data Quality, experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Designed SQL Server database objects (tables, stored procedures, functions and views) to support outsourcing data integration (SSIS), analysis, and various business processes.
• Experience in Importing/Exporting Data from various data sources like MS Access, Excel Files, Oracle, DB2, XML Files and Flat Files using DTS utility. Involved in ETL transformation of OLTP data to the Data Warehouse implementing all transformations using SSIS and SQL commands.
• Experience in installing, configuring, developing and deploying reports using SQL Server Reporting Services (SSRS)
• Extensive experience in Agile software development and SCRUM methodology.
• Experience with Mainframe systems (COBOL, JCL, CICS, VSAM, DB2, IMS, IDMS) and also conversion of Mainframe data to ETL Staging tables.
• Experience in creating semantic layer data modelling for business analysis.
• Expertise in Gathering and Analyzing Information Requirements, Data Analysis, Data Architecture, Business (E - R) modeling, Dimensional Modeling, ETL Design.
• Experience in Informatica Power Center 9x/8.x with Oracle 11g/9i/10g, experience in SSIS and SQL Server Data Warehouse in Microsoft DW/BI environments.
• Experience in implementing Data warehousing solutions involving Dimension modeling and Snow flake schema implementation (3 NF).
• Experience in integration of various data sources with multiple Relational Databases like SQL Server, Teradata, Oracle and DB2.
• Expert in creating Complex Crystal Reports Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports.
• Experience on various Software Development Life Cycles including Analysis, Design, Development and Testing to solidify client requirements in conjunction with Software Developers.
• Experience in RDBMS (Oracle) PL/SQL, SQL, Stored Procedures, Functions, Packages, Triggers worked with Terabytes of Volume databases.
• Hands on experience in migrating database application from legacy to newer technology, data movement, data mapping
• Good experience in data transformation, data mapping from source to target database schemas and also data cleansing.
• Used Teradata Fast Export utility to export large volumes of data from Teradata tables and views for processing and reporting needs.
• Includes Requirement Study, Analysis, Design, Development, Integration, implementation, maintenance and testing of various client server and N-tier web applications.
• Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data Warehousing environments.
• A good expertise in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS) and Informatica.

TECHNICAL SKILLS

Data Modeling Tools: Erwin r9, Erwin r8, Erwin r7.1/7.2, Rational Rose 2000, ER Studio and Oracle Designer

OLAP Tools: Microsoft Analysis Services, Business Objects, and Crystal Reports 9

ETL Tools: Microsoft DTS/SSIS, SSRS and Informatica 7.1.3

Programming Languages: SQL, T-SQL, Base SAS and SAS/SQL, HTML, XML, C#.Net, VB.NET

Database Tools: Microsoft SQL Server 2000/2005/2008/2012, Teradata, Oracle 10g/9i, and MS Access

Packages: Microsoft Office 2010, Microsoft Project 2010, SAP and Microsoft Visio, Share point Portal Server 2003/2007.

Operating Systems: Microsoft Windows 9x / NT / 2000/XP / Vista/7 and UNIX

Quality Assurance Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, Quality Center, Rational Functional Tester

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Sr. SQL Server Developer/Admin

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources (Teradata) for data analyzing, deploying and dynamic configuring of SSIS packages.
• Created SSIS package to extract, transform and load data from Flat File to Flat File and Flat File into the data warehouse and to report-data mart, using Lookup, Fuzzy Lookup, Derived Columns, Conditional Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used C#.Net to develop different modules of the end-user interfaces and different SSIS packages.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed complex script to load operational data to Support Direct Mail and Email Campaigns.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2012.
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS /SSIS package
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Defined security models with row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC).
• Took part in creation of star schema and snowflake dimensional schema in MS analysis services (SSAS).
• Generate periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2012.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2012 with the use of the Query Analyzer and Database Engine Tuning Wizard.

Environment: MS SQL Server 2008/2012/2014, MS SQL Server Reporting Services (SSRS) 2008R2/2012, MS SQL Server Integration Services (SSIS) 2008R2/2012, MS SQL Server Analysis Services (SSAS) 2008R2/2012, C#.Net, Microsoft Visual Studio, MS Excel, MS Visio 2013.

Confidential, Livonia, MI

Sr. SQL Server Developer/Admin

Responsibilities:

• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Responsible for different Data mapping activities from Source systems
• Involved in data model reviews with internal data architect, business analysts, and business users with explanation of the data model to make sure it is in-line with business requirements.
• Involved with Data Profiling activities for new sources before creating new subject areas in warehouse
• Worked on various database environment scripts to move or load data from landing, Test and production.
• Experienced in implementing various logic using objects like Tables, Joins, Views, Roles and Constraints using Data Definition Language (DDL), Data Manipulation Language (DML).
• Extensively worked Data Governance, i.e. Metadata management, Master data Management, Data Quality, Data Security
• Expertise in executing complex queries using stored procedures, Triggers, Cursors, User Defined Functions using SQL in observing Business Rules.
• Created numerousreportsviaCrystalReportsfor the user community. Thesereportswere written from SQL tables used in the applications.
• Experience in Extraction, Transforming and Loading (ETL) data flows using SSIS, Bulk Insert, creating mappings/workflows to extract data from Oracle, DB2, SQL Server, Excel and Flat File sources and load into various Business Entities.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns on Teradata database as part of data analysis responsibilities.
• Performed complex data analysis in support of ad-hoc and standing customer requests
• Delivered data solutions in report/presentation format according to customer specifications and timelines.
• Used Reverse Engineering approach to redefine entities, relationships and attributes in the data model as per new specifications in Erwin after analysing the database systems currently in use.
• Designed and developedCrystalReportslike Cross TabReports, Top NReportsfor highlighting significant data, summaryreportswith drill-down capabilities.
• Strong SQL Back End Programming in both Web based and Client Server environment
• Experience in maintain database security regulations and procedures
• Enforced referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Involved in SQL Development, Unit Testing and Performance Tuning and to ensure testing issues are resolved on the basis of using defect reports.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Provided 24*7 on-call production database support and maintenance
• Experience 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: Windows XP, Windows7, Informatica Power Center, QTP 9.2, Test Director 7.x, Load Runner 7.0, UNIX AIX, PERL, Shell Scripting, Data Flux, Quality Center 8.2, SQL, MS Sql 2008/2012, TOAD, PL/SQL, Flat Files, ADO.Net, SSRS, Crystal Reports, C#, TFS, Crystal 1.1.

Confidential, Rockville, MD

Sr. SQL Server Developer/Admin

Responsibilities:

• Part of the team responsible for the analysis, design and implementation of the business solution.
• Developed the logical data models and physical data models that capture current state/future state data elements and data flows using ER Studio.
• Developed a Conceptual model using Erwin based on requirements analysis.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Involved in Data Mapping activities for the data warehouse.
• Produced PL/SQL statement and stored procedures in DB2 for extracting as well as writing data.
• Expertise in executing complex queries using stored procedures, Triggers, Cursors, User Defined Functions using SQL in observing Business Rules.
• Experience in Extraction, Transforming and Loading (ETL) data flows using SSIS, Bulk Insert, creating mappings/workflows to extract data from Oracle, DB2, SQL Server, Excel, CSV and Flat File sources and load into various Business Entities.
• Maintain database security, create, modify and manage users accounts; grant privilege and restrict access to database objects
• Data base security worked for encryption with true crypt and Symantec for FDIC.
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
• Developed Star and Snowflake schemas based dimensional model to develop the data warehouse.
• Created Physical Data Model from the Logical Data Model using Compare and Merge Utility in ER/Studio and worked with the naming standards utility.
• Reverse Engineered DB2 databases and then forward engineered them to Teradata using ER Studio.
• Provided source to target mappings to the ETL team to perform initial, full, and incremental loads into the target data mart.
• System level testing of Geographic Information System (GIS) software algorithms and databases was conducted for compliance with telephony specifications and functional requirements.
• Responsible for migrating the data and data models from DB2 to SQL server environment.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic. Extensively worked on the naming standards which incorporated the enterprise data modeling.
• Developed and refined business development strategies, and developed and delivered software training and consultation based on best practices of demographic intelligence and GIS.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• Strong Experience designing for Web Applications inCrystalReports, SSRS. Involved in generating thereportsusing Visual StudioCrystalReports
• Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development and production environments for implementation and maintenance of user security.
• Worked closely with the ETL SSIS Developers to explain the complex Data Transformation using Logic.

Environment: Erwin r9, SQL Server 2008R2/2012, SQL Server Analysis Services 2008, SSIS 2008, SSRS 2008, Oracle 10g, Business Objects XI, Rational Rose, MS Office, MS Visio, Crystal Report.

Confidential

SQL Server Developer/Admin

Responsibilities:

• Developed system objectives, requirements, business models, user models, and business rules.
• Designed and validated the business processes of the application with use case diagrams, class diagrams, and sequence diagrams using UML Enterprise Architecture
• Assisted in designing web application architectures to utilize and work within corporate security guideline.
• Designed and coded 3-tier applications with front-end development in MS VB.NET, C#.NET, ASP.NET, SQL Server 2005
• Designed and coded stored-procedures in MS SQL Server 2000.
• Extensively used ADO.NET technology to get advantage of disconnected data programming using technologies like Datasets, Data Adapter, Data Reader, Data Tables, Data View and Data Grid.
• Developed win forms using C# environments and ADO.Net.
• Involved in database design, writing stored procedures using T-SQL.
• Detailed documentation and code reviews.
• Involved in database operations using ADO.NET.
• Generated reports using Crystal Reports.
• Designed LDM/ PDM for Coverage Model / On Line Watch List Management using Erwin for Global Anti Money Laundry & Economic Sanctions.
• Involved in preparing Logical Data Models/Physical Data Models.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Designed Logical/ Physical Data Model for E-Delivery System Using ER-Studio.
• Created SQL Loader Scripts, table sizing, indexing, table partition, SQL tuning.
• Created/ Tuned PL/SQL Procedures, SQL queries for Data Validation for ETL Process.
• Created Validation reports/System integration reports by Oracle Developer Suite 10g.
• Extracted data from various sources like Oracle, Netezza and flat files and loaded into the target Netezza database
• Created DDL, DML scripts. Created and worked with X-Reference tables for data validation between difference data marts/Databases
• Created PL/SQL procedures, triggers, generated application data, created users and privileges, used oracle utilities import/export.
• Extracted data from various sources like Oracle, Mainframes, flat files and loaded into the target Netezza database.
• Designed data models with Confidential - ERC standards up to 3rd NF (OLTP/ODS) and de normalized (OLAP) data marts with Star & Snow flake schemas.
• Created more than 20 New Models and with more than 100 tables. Used Star Schema and Snow Flake Schema for data marts / Data Warehouse.
• Created DHTML using PL/SQL Tool kits, packages, Dynamic SQL, used Apache
• Provided conceptual and technical modeling assistance to developers and DBA's using Erwin and Model Mart. Validated Data Models with IT team members and Clients.
• Worked on IBM Information Analyzer to profile the data and generate various reports
• Data Analysis and Application Testing Tuning using Analyze and Explain plan.
• Extracted the source data from Oracle tables, MS SQL Server, sequential files and excel sheets.
• Developed mappings in Informatica to load the data from various sources includes SQL server, DB2, Oracle, Flat files into the Data Warehouse, using different transformations like Source Qualifier.

Environment: Oracle 8i, PL/SQL, SQL Loader 8.1, Toad 4.0, UML, Erwin 3.5, K-Shell, Erwin3.5, PL/SQL TOOL KIT, Perl, JDBC, Toad 3.0, PL/SQL, C#.NET, Microsoft .NET Framework 2.0, ADO.NET, SQL Server 2008, Windows NT, Reporting Services (SSRS).

Confidential

SQL Server Developer

Responsibilities:

• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Conducted analysis and profiling of potential data sources, upon high level determination of sources during initial scoping by the project team.
• Developed logical/ physical data models using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Worked with ETL to create source to target mappings and performed validation for source to target mappings.
• Analyzed large number of COBOL copybooks from multiple mainframe sources (16) to understand existing constraints, relationships and business rules from the legacy data.
• Involved in data model reviews with internal data architect, business analysts, and business users with in depth explanation of the data model to make sure it is in line with business requirements.
• Understood basic business analyst concepts for logical data modeling, data flow processing and data base design.
• Created Physical Data Model (PDM) for the OLAP application using ER Studio.
• Participated in JAD session with business users and sponsors to understand and document the business requirements in alignment to the financial goals of the company.
• Worked with DBA to create the physical model and tables.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Collaborated with the Reporting Team to design Monthly Summary Level Cubes to support the aggregated level of detailed reports. Worked on the Snow-flaking the Dimensions to remove redundancy.
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.

Environment: Erwin 4.0, Erwin 3.5.2, Toad, PL/SQL, Oracle 9i, SQL Server 2000, Windows 2005, ER Studio 7.1.1, Quest Central for DB2 v 4.8, COBOL, Tera Data, Microsoft SQL Reporting Services.