PROFESSIONAL SUMMARY:

• 7+ years of experience in designing, developing, maintaining and building large business applications such as data migration, integration, conversion, data warehouse and Testing.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005/2008 in MS SQL Server 2000/2005/2008 .
• Experience in various Business Domains like Finance, Insurance, Pharmacy and Health Care dealing with High transactional, Multi - Server Production Environment.
• Excellent command on SQL SERVER 2008/2005, T-SQL and PL/SQL Programming.
• In-depth knowledge of Transact-SQL (DDL, DML), Indexes, Views, Stored Procedures and User defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Expert in all phases of Software development life cycle(SDLC) - Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation.
• Well versed in Normalization/Demoralization techniques for optimum performance in relational and dimensional database environments.
• Experience with T-SQL (DDL and DML) in constructing tables, user defined functions, views, complex stored procedures, clustered and non-clustered indexes, relational database models, data dictionaries, data integrity and appropriate triggers to facilitate efficient data manipulation and consistent data storage.
• Familiarity with DBA Activities in Development/Test environments including Backups, Restores, Data refreshes, Security and User management, Performance Tuning
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Experience in SQL Optimizing by using SQL Profiler, Database Tuning Advisor, DBCC Commands and Query Execution Plans.
• Experienced in implementing slowly Changing Dimension wizard and Check Sum Transformation to load data into slowly changing dimensions in data warehouse.
• Expert in scheduling jobs, SSIS Packages and sending Alerts using SQL Mail.
• Expert in generating Sub reports, Drill down and Drill through reports with drop down menu options, sorting the data, defining sub totals in SSRS 2008.
• Proficient in handling parameterized reports in SSRS 2008.
• Used custom adapters and out of the box BizTalk adapters & accelerators such as SQL, File, HTTP.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions using MS Analysis Services 2008/2005.
• Extensive knowledge in database maintenance, SQL query optimization & performance tuning using performance tools like SQL Profiler, Index Tuning Wizard, Database consistency check using DBCC utilities and Database Engine Tuning Advisor.
• Extensive experience in ERP application SAP as ABAP/4 technical developing consultant. Good experience with MM, SD and HR Modules.
• Excellent interpersonal and communication skills with strong analytical and problem solving skills. Quick learner, self-motivated and very good team player with ability to understand and mingle with peers.

TECHNICAL SKILLS:

Databases: MS SQL server 2000/2005/2008 , Oracle, MS Access.

ERP Applications: SAP R/3, 4.7, ECC 5.0, 6.0.

Languages: Transact- SQL, SQL, HTML, XHTML, C#, VB script.

Operating Systems: Windows NT/98/2000/XP/Vista/2003, MS-DOS.

OLAP/Reporting Tools: SQL Server Analysis Service (SSAS), SQL Server Reporting service (SSRS), Crystal Reports 9/10/XI.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS.

Other Tools: Erwin, Microsoft Visual Source Safe, Microsoft Office, MS Visio.

Data Modeling Tools: Erwin tool, Microsoft Visio 2000/2003.

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, DBCC, BCP, SQL server profiler.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

SQL Server Developer/ MS BI

Responsibilities:

• Worked on building and maintaining SSIS packages.
• Built packages using variety of transformations like script task, data flow task, data conversion, execute SQL task and for each loop containers
• Created XML, Excel, CSV and Text (Tab Delimited) files
• Also worked on loading the data from XML files to the database
• Loaded data into the database from a different kind of File formats like Excel, CSV and Text Files
• Dealt with creating and optimizing Stored Procedures which had to be constantly changed or modified according to the business need
• Provided front end (Entity Framework) by creating Views to suffice the needs
• Used TFS to save code and packages, also to move code to different environments like QA and Production
• Involved in Performance Tuning of Stored Procedures and SSIS packages that were built.
• Built Error handling techniques for all the packages created.
• Worked with Team Track System.
• Created Parameterized, Drill down and Drill-through reports using SQL Server Reporting Services (SSRS).
• Support and maintenance of Microsoft BizTalk 2010 system for the purpose of different processes between customers, vendors and suppliers and for internal Systems.
• Generated XML schemas, designed orchestrations including De batching, Correlation and Retry Mechanism, developed complex maps for vendor integration.
• Developed a custom pipeline component for encoding the data coming from the vendor into proper XML format.
• Worked on BI reporting using excel with power pivot.
• Created number of cubes with dimensions, calculations, measures using SQL server analysis services representing aggregation in several different ways using custom groupings that the company will use to analyze performance.
• Created several MDX queries with waterfall charts for business requirements.
• Implemented BI dashboard using MOSS 2007 report center and excel services producing different summary results based on user view and role .
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Checked in and checked out SSIS packages into TFS.
• Worked on TFS and visual studio 2010.
• Developed multi-dimensional databases (MDDB), OLAP cubes and data marts using SQL Server Analysis Services (SSAS) that stored and maintained the data.
• Working knowledge in Data modeling, creating star and snowflake schemas in SSAS.
• Created Report Snapshots to improve the performance of SSRS.
• Developed an Address Subscriber data mart that provided accurate address and current demographic data for current and past subscribers used in marketing applications to develop accurate and timely target market campaigns. Using the data mart, call lists were extracted that were accurate and targeted the campaign demographics.

Environment: Microsoft SQL Server 2008/2008R2/2012, Windows 7, Microsoft Visio, Microsoft Excel, BizTalk 2010, SQL Server Integration Service (SSIS), SQL Server Analysis Services (SSAS), SQL Server Management Studio (SSMS), Team Foundation Server (TFS) and Microsoft Visual studio 2008/2010.

Confidential, Irving Texas

Database Engineer/MS BI Developer

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes.
• Created SSIS packages to transfer data from Oracle to SQL server using different SSIS components and used configuration files and variables for production deployment.
• Developed SSIS Packages to Consolidate date from various data Sources and also Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs) and converted XML to SQL reporting.
• Involved in daily loads (FULL & INCREMENTAL) into Staging and ODS areas, troubleshooting process issues and errors.
• Created dynamic parameterized reports
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups.
• Worked on BI reporting using excel with power pivot, MOSS, PPS.
• Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Handled exceptions in all BizTalk processes using common error handling orchestration for routing failure errors and configured process to send alerts to System Admins.
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Used SSIS 2008 to create ETL packages (.dtsx files) to validate, extract, transform and load data to Data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.
• Made Packages Parameterized using Configuration Manager and Implemented Logging in SSIS.
• Created reports using Microsoft office performance point server 2007 dashboard designer extracting from SQL server 2008 OLAP data sources and deployed to share point sites.
• Created analysis solution based upon the data in the staging structure. This is to include a cube with multiple dimensions, calculations, measures, key performance indicators, to analyze the profitability and costs.
• Created MDX waterfall charts based on a result data coming from a SSAS cube.
• Created, Optimized and Partitioned the OLAP Cubes by designing aggregations and usage based aggregations.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS). Developed multi-dimensional databases (MDDB), OLAP cubes and data marts using SQL Server Analysis Services (SSAS) 2005 that stored and maintained the data.
• Scheduled and monitored various jobs like package execution and cube processing using the SQL Server Agent.
• Used TFS to save code and packages, also to move code to different environments like QA and Production.
• Created SQL Server Reports using SSRS 2005.
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Involved in data modeling for the application and created ER diagram using Erwin.
• Defined relationship between tables and enforced the referential integrity constraints.
• Created Clustered and Non-Clustered Indexes to increase the performance of database.
• Created Multi - column unique and no unique Non-Clustered Indexes.
• Created Maintenance Plans and setup log files to monitor jobs.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL queries and Stored Procedures.
• Creating joins and sub-queries for complex queries involving multiple tables.
• Optimized query performance by creating indexes.
• Using DDL and DML for writing triggers, stored procedures, and data manipulation. Requirement gathering and creating mapping specs.

Environment: MS SQL Server /2005/2000, Windows Enterprise Server 2003/2008, SQL Server Analysis Services (SSAS), Reporting Services (SSRS 2005), Business Intelligence Development Studio (BIDS), BizTalk 2010, SQL Server Integration Service

Confidential, Augusta, Maine

SQL Server Developer SSRS/SSIS/SSAS

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS).
• Created some SSIS packages to incrementally load data to the reporting database on which the reports are build.
• Extensively Used SSIS transformations like Lookup, conditional spilt, multicast, derived columns, Data Conversion, Aggregate and tasks like Execute SQL Task, Execute Package Task, Script Task.
• Good knowledge of defining, developing and deploying Star Schema, Snow flake Schema and Dimensional Data modeling using MS SQL Server Analysis Services (SSAS).
• Experience in working creating Multidimensional cubes using SSAS for sales, Inventory, operational, merchandising and financial environment.
• Used ETL to develop jobs to extract, transform and load data into data warehouse.
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Using BizTalk Administration Console for monitoring the message flows.
• Used complex stored procedures, in BizTalk application and developed console applications for monitoring the status.
• Created multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications.

Environment: Windows XP Professional enterprise, SQL Server 2008 R2, Oracle 10g,SQL Integration Services(SSIS), SQL Server Analysis Services (SSAS), BizTalk 2010, Business Intelligence Development Studio, Visual Studio 2008/2005, OLE DB.

Confidential, Lansing MI

Sr. SQL Server ETL developer

Responsibilities:

• Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Created Indexes to get the high level performance.
• Performing the ETL operations to support the data loads and transformations using SSIS.
• Involved in migration from Oracle to SQL Server 2005 using SSMS and SSIS.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Implemented automated backup and database maintenance / cleanup jobs.
• Managing Logins, Users, Roles and User permissions.
• Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: SQL Server 2005 Business Intelligence Development Studio (SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, SQL Server Reporting Services SSRS and SQL Server Management Studio SSMS )

Confidential, Sacramento, California

SQL Server ETL developer

Responsibilities:

• Created new tables, written stored procedures using T-SQL for Application Developers. Performed data conversions from flat files into a normalized database structure.
• Created Triggers to enforce data and referential integrity and defined Check constraints, Business Rules, Indexes, and Views.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Created Cross-Tab, Drill-down, Cascaded Parameterized and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.
• Generated SSRS reports with desired forms(Webpage, PDF, Excel and etc.) to present statistics information according to business requirement
• Assisted the application team in data modeling and T-SQL coding
• Created data models with Report Builder to provide a template for end-users for creating reports by themselves with pre-selected group of relational tables
• Deployed the created reports into SharePoint and Report Manager and created data driven subscriptions for different users in Report Manager.
• Successfully managed Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Used Red gate SQL Compare and SQL Data Compare for pushing changes from test servers to production servers
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

Environment: Windows Server 2003 EE, Microsoft SQL Server 2005/2008, SSRS, SSIS, Red Gate SQL Compare, Microsoft Visual Studio 2008, Team Foundation Server, Microsoft Entity Frame Work.

Confidential, Portland Oregon

SQL Server BI Developer

Responsibilities:

• Created new tables, written stored procedures using T-SQL for Application Developers. Performed data conversions from flat files into a normalized database structure.
• Created Triggers to enforce data and referential integrity and defined Check constraints, Business Rules, Indexes, and Views.
• Installing and Configuring SQL Server 2008, Integration Services (SSIS) and Reporting services (SSRS) for QA and DEV environments.
• Used TDE for encrypting and decrypting the secured information of the customers.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Created Cross-Tab, Drill-down, Cascaded Parameterized and Sub-Reports using RDL. Promoted RDLs to Reporting Service Server.
• Generated SSRS reports with desired forms(Webpage, PDF, Excel and etc.) to present statistics information according to business requirement
• Assisted the application team in data modeling and T-SQL coding
• Created data models with Report Builder to provide a template for end-users for creating reports by themselves with pre-selected group of relational tables
• Deployed the created reports into SharePoint and Report Manager and created data driven subscriptions for different users in Report Manager.
• Successfully managed Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Used Red gate SQL Compare and SQL Data Compare for pushing changes from test servers to production servers
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Adviso.

Environment: Windows Server 2003 EE, Microsoft SQL Server 2005/2008,SSRS,SSIS,RedGate SQL Compare, Idera’s SQL Diagnostic Manager, Microsoft Visual Studio 2008, Team Foundation Server, Microsoft Entity Frame Work.

Confidential

SAP ABAP Developer

Responsibilities:

• Designed Smart form for displaying shipping delivery note. Outbound deliveries for the transaction VL02N. Assigning a Smart form to the output type using NACE transaction (SPRO Settings).
• Analysis of business processes, envisioning and mapping the processes for SAP R/3 MM / SD implementation.
• Identification and resolution of gaps in business processes at process or activity or transaction level.
• Design of key Data elements and finalization of organization structure. Configuring SAP MM settings as per requirements of the processes. Areas covered included purchasing order processing, outline agreements, scheduling agreements, pricing, account assignments, valuation, vendor performance evaluation, inventory management and configuration for material & vendor master. Integration with SD module, material master settings for MM. Integration with SD module, material master settings for MM.
• Developing prototype based on the above specifications and demonstrations for obtaining design sign-off.
• Analysis and design of authorization profiles based on roles and responsibilities.
• System testing and user acceptance testing of the configured solution.
• Data planning for data conversion & data migration. Data migration - providing data formats.
• Providing functional - technical specifications for MM / SD Transaction / Report / layout sets. Rollouts to other business units. This includes identification of difference in business processes and configuration for the difference, analysis and design of authorization profiles and user manuals.

Environment: SAPR/3V4.6 (Module: MM, SD)