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 Server 2005/2008/2012/2014.
• 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.
• Process - focused and result-oriented team player possessing excellent work ethics having worked in different roles from team member, technical lead to Centre of Excellence ( COE ) for different technical challenges from various teams.
• 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, Tera data, 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/2014.
• Expertise in creating Report Models 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 2012/2014.
• 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 Design Aggregations 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/2014 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, Bloomington, IL

Sr. SSIS/ SSRS/ SSAS Developer

Responsibilities:

• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Develop System Center jobs and custom PowerShell scripts to gather data.
• Project lead for Account Payable data warehouse project development and implementation.
• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2008/2014
• Defined Check constraints, Business Rules, Indexes, and Views.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler, Data Engine Tuning Advisor and index tuning wizard.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2012/2014 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.
• Development of .NET batch applications which processes high volume of data.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Developed Query for generating drill down and drill through reports in SSRS2012/2014.
• Uploaded reports on to the report manager and organized them into folders.
• 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 2012/2014.
• 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 Merge Agent. Created Distribution Databases, updated Publishers, created & managed Publications, managed Replication monitors.
• Managed the migration of SQL Server 2008 databases to SQL Server 2012/2014.
• Perform Capacity Monitoring and short and long-term Capacity Planning in collaboration with development resources and System Administrators.

Environment: MS SQL Server 2014/2012, SSIS, SSRS, SSAS, T-SQL, Excel, Oracle 10g

Confidential, PENNINGTON, NJ

Sr. SQL SSIS/SSRS Developer

Responsibilities:

• Project Technical lead for a team of 6 members.
• 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 Integration Service (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 Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs 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 2008/2012, SSIS, SSRS, SSAS, T-SQL, Excel

Confidential

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 SQL SSIS Packages to extract data from various data sources such as Excel and flat files into SQL server 2008 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.
• 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 Wells Fargo 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 parallel period, filter, ancestors and cross join MDX queries.
• Translated business requirements to smart solutions in Salesforce.com.
• Developed Aggregations, partitions and calculated members 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 SQL server 2008 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 SQL Server 2008 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 SQL Server profiler.
• Experience in planning and implementing the Replication of MS SQL Server 2005 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).
• Worked on upgrading/changing all the database objects from 2000 to make them compatible to the schema changes in 2005.
• 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 2005/2008, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, Windows Performance Monitor.