SUMMARY

• Over 8 +years of Experience in Data Warehousing and Business Intelligence applications design, development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS). Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2000/ 2005/2008/2012.
• Expert in all areas of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, relational database models, data dictionaries, and data integrity.
• Experience in Interacting with Business users to analyze the business process and transforming requirements, performing ETL, documenting and rolling out the deliverables.
• Expertise in Extract Transform Load (ETL) and Data Transformation Services (DTS).
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expertise in Extraction, Transformation, Loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using SSIS.
• Experience in data migration (using tools like Bulk Insert, DTEXEC and DTEXECUI) between different homogeneous/heterogeneous systems and SQL Server.
• Knowledge of risk management principles and practices.
• Expertise in creating SQL server Reports using SSRS 2005/2008/2012.
• Expertise in creating ReportModels for building Ad hoc reports using SSRS.
• Hands - on development experience in .Net based Applications
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL.
• Experience in developing SSAS projects using MDX in MSSQL Server 2005.
• Experience in Designing, Building the Dimensions, cubes with start schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
• Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL.
• Skilled in Query Optimization, Performance tuning, and providing database security by creating users, permissions, and role-based access to data.
• Experience in creating XML files and XSD schema files.
• Developed reports using global variables, expressions and functions using SSRS.
• Excellent knowledge on Object Oriented Analysis and Design concepts.
• Excellent time management and strong team player.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Perspectives, Partitions and DesignAggregations in cubes using SSAS.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.

TECHNICAL SKILLS

ETL Tools: DTS, SSIS, Informatica Power Center

Data Modeling: Erwin, Rational Rose, and Microsoft Visio

Database: Oracle 11g/10g/9i/8i, MS Access, MS SQL Server 2005/2008/2012 and DB2

Languages: SQL, PL/SQL, T SQL

Reporting Tools: SSAS, SSRS, Crystal Reports, Excel

Testing Tools: JIRA, Quality Center

Concepts: Data Structure, DBMS, Systems analysis and design, Object Oriented Programming, Usability Heuristics, Data Mining, Shell scripting

PROFESSIONAL EXPERIENCE

Confidential, Oak Brook, IL

SQL/SSIS Developer

Responsibilities:

• Designed and developed end-to-end ETL process for Wellpoint DSS.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the Datamart.
• Analyzed and created Facts, Dimension tables. Modeled the data warehousing data marts in Star join schema.
• Worked on loading of data from several flat files sources using Teradata MLOAD & FLOAD.
• Extensively used stored procedures and also worked with parallel processing.
• Created snapshot for the transactional tables in distributed databases and also created Triggers, Procedures and Functions for the backend Development.
• Created shared folders, local and global shortcuts to reuse metadata.
• Developed COBOL programs, JCL and Abinitio ETL job to extract, transform and load data into DW, and write SQL scripts for OLAP, ad-hoc and query reports for Business Object.
• Presentation of the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.
• Used Autosys for scheduling the jobs.
• Extracted data from source systems to a datamart running on Teradata using utilities like MultiLoad, OLELoad and FastLoad.
• Tools utilized in the implementation such as: Queryman, BTEQ, Teradata Parallel Transporter(TPT), WinDDI, QUERYMAN, MLOAD, FASTLOAD, FASTXPORT, TDQM, PMON, DBW, DB2, COBOL, SQL, JCL, MVS-TSO/ISPF, File-Aide, ChangeMan, DTS and OLEDB.
• SDLC and SDM Methodologies are used for SLA in implementation and development of projects.

Environment: NCR Teradata, Abinitio, Oracle10g/9i, SQL Server, BTEQ

Confidential, East Providence, RI

Sr.SSIS/ SSRS/ SSAS Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Provided architecture/development for initial load programs to migrate production databases from Oracle data marts to Teradata data warehouse, as well as ETL framework to supply continuous engineering and manufacturing updates to the data warehouse (Oracle, Teradata, MQ Series, ODBC, HTTP, and HTML).
• Performed the ongoing delivery, migrating client mini-data warehouses or functional data-marts from Oracle environment to Teradata.
• Migrate/Convert Data from Oracle to Teradata DW using Oracle Data Pump/OWB, OLE DB and DTS.
• Design and Develop DataStage ETL jobs and test cases on Teradata.
• Write Teradata SQL, BTEQ, MLoad, OLELoad, FastLoad, and FastExport for Ad-hoc queries, and build Unix shell script to perform ETL interfaces BTEQ, FastLoad or FastExport, via Hummingbird and Control-M software.
• Creating Stored Procedures in MS SQL Server 2005.
• Worked in extracting data from legacy Systems such as main frames, oracle to Teradata. Integrating Campaign-Management Data Mart and Decision Support Data-mart for individual clients running under Sun Solaris.
• Created ETL Scripts & Procedures to extract data and populate the data warehouse using Oracle Gateway to Teradata.
• Created summarized tables, control tables, staging tables to improve the system performance and as a source for immediate recovery of Teradata database.
• Performance tuning for Data warehouse Database (Teradata) and Data warehouse operations.
• Understanding of current Risk management tools and techniques.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2008/2012.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Configured MERGE Replication using Snapshot agent and MergeAgent. Created Distribution Databases, updated Publishers, created & managed Publications, managed Replication monitors.
• Managed the migration of SQL Server 2008 databases to SQL Server 2012.
• Perform Capacity Monitoring and short and long-term Capacity Planning in collaboration with development resources and System Administrators.

Environment: MS SQL Server 2012/2008/2005/2000/7.0 , DTS, SSIS, SSRS, SSAS, T-SQL, Excel, Oracle 10g

Confidential, PENNINGTON, NJ

Sr.SQL SSIS/SSRS Developer

Responsibilities:

• Participated in gathering User Requirements and System Specifications.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Created and executed SQL Server IntegrationService (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheets to SQL Server.
• Migrated DTS packages to SSIS packages and modified the packages with new features of SSIS.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Worked as a student liaison to promote Risk Management major to students and corporate contacts
• Created Dimensionsandcubes with star schemausingSQL Server Analysis Services (SSAS).
• Created multiple reports (SSRS) in Drillmode using tables, financial tables, crossestabs and chart.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server.
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SQL scripts to load the custom data into Development, Test and production Instances using Import/Export. Created scripts to create custom Tables and Views.
• Responsible for testing to optimize the procedures and triggers to be used in production. Involved in project planning also schedule for database module with project managers.

Environment: MS SQL Server 2005, DTS, SSIS, SSRS, SSAS, T-SQL, Excel

Confidential, Des Moines, IA

SQL SSIS/SSRS Developer

Responsibilities:

• Involved in the support the specific needs of hedge funds, fund-of-funds and private equity funds and registered investment products.
• Involved in design, development and implementation of SSIS, SSRS and SSAS.
• Developed SQLSSIS Packages to extract data from various data sources such as Excel and flat files into SQLserver 2005 using different transformations like derived column, sort, and aggregate transformations.
• Integrated Database Maintenance jobs to perform Full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
• Analyzed and designed new .NET Web, Batch and WCF application from design to completion stage.
• Tuned the database to perform efficiently by managing databases using the options to grow or shrink database files and monitor the size of the transaction log.
• Tuned the performance of SQL queries and Stored procedures using SQL Profiler.Involved in database and log backups & restoration, backup strategies, scheduling.
• Worked on upgrading/changing all the database objects from 2000 to make them compatible to the schema changes in 2005.
• Used SQL profiler to view indexes performance to mostly eliminate table scan.
• Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Extensively used TSQL to manipulate and architect to produce results for users.
• Used multiple join statements to retrieve data from multiple tables.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.
• Created various DTS packages for data transfer and migration.
• Designed and implemented parameterized reports, Drill down reports for Confidential Mortgage Loan organization.
• Created reusable code using the Salesforce developer toolkit
• Managing various mortgage processes across different reports and provided primary Admin and production support for these reports.
• Developed SQL mortgage reports using SSRS. Developed optimal stored procedures and queries to create data sets for reports. Designed Drill through Ad-hoc Reports.
• Created parallelperiod, filter, ancestors and crossjoinMDX queries.
• Translated business requirements to smart solutions in Salesforce.com.
• Developed Aggregations, partitions and calculatedmembers for cube as per business requirements.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQLserver 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQLServer 2000/2005 Analysis Services (SSAS) and Reporting service (SSRS).

Environment: SSIS, SSRS, SSAS, MS Excel, Oracle, Toad.

Confidential

MS SQL Server Developer

Responsibilities:

• Experience in support and management of databases, systems, applications and Application Development.
• Experience in Implementation of Production environment Hardware requirements and application support.
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005 and MS SQL Server 2000 databases/ servers.
• Implementation of Point in time Backup and recovery plans of all databases and maintain documentation. Schedule the Administrative Tasks (like database integrity checks and maintenance plans).
• Extensive exposure to creation of databases, objects, stored procedures, triggers, security, DTS (i.e. Import and Export), BCP, Transact-SQL, and SQL Server Agent and SQLServer profiler.
• Experience in planning and implementing the Replication of MS SQL Server 2000 Databases and databases Backup recovery strategy.
• Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers. Used Log Shipping Technique for warm backup solution for MS SQL Server databases.
• Very good experience in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.
• Experience on working with BRP (Business recovery plans) and EPP exercises (Emergency prepared plans)
• Creation and maintenance of Users security permissions and Migrating the entire database objects from one server to another server and database to another database.
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2005 Integration Services (SSIS), SQL Server Reporting Service (SSRS), and SQL Server Analysis Service (SSAS).
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Exposure in analysis services.

Environment: Windows 2000 Advanced Server, SQL Server 2000, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, Windows Performance Monitor.