SUMMARY:

• 9+ years of IT experience in Data Design and Development on Microsoft SQL Server 2008/2005/2000 , T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS and Data-warehousing.
• Experience in using Business Intelligence tools(SSIS,SSAS,SSRS) in MS SQL Server 2008
• Extensive experience with T-SQL in constructing, Tables, implementing stored Procedures, Functions, Views, CTE, CURSORs and Data Integrity.
• Extensive knowledge of Normalization and Relational Database Management Systems.
• Hands on experience on various SQL Server Services like Integration Services (SSIS), Reporting Services (SSRS).
• Great ability to create and manage various database objects like tables, views.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, user defined functions.
• Experience in Performance Tuning and Query Optimization.
• Experienced in using ETL tools in (SSIS) MS SQL 2008,MS SQL 2005 and DTS in MS SQL 2000
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
• Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysis and data migration by transferring them using SSIS packages.
• Knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Expert in Data Migration. Formulated data from legacy systems. Established cleansing, Mapping and enrichment.
• Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server 2008/2005/2000 .
• Involved in Query Optimization and Performance Tuning using tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor
• An enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills with good work ethics.

TECHNICAL SKILLS:

Database Management System: MS SQL SERVER 2012/2008R2/ 2008/2005/2000 , MS-Access,DB2

Database Utilities: Enterprise Manager, query analyzer, SQL server, Profiler, SQL Server Management Studio.

ETL Tools: SQL Server integration services (SSIS), Data Transformation Services

Reporting Tools: MS SQL Server Reporting Services, Qlik View

Programming Language: TSQL, SQL

Operating Systems: WindowsServe 2000/2005/2008/2008 R2/2012

Utility Tools: MS Office, Visual Source Safe 6.0

PROFESSIONAL EXPERIENCE:

Confidential, WoodLand Hills, CA

MS SQL Server / SSIS / SSRS / BI Developer

Responsibilities:

• Created SSIS packages to migrate data from legacy systems to the Data Warehouse environment.
• Developed SSIS packages to create reports in various formats like Excel, CSV, Text and XML.
• Scheduled SSIS Packages as SQL Jobs using SQL Server Agent.
• Involved Interaction with Project Managers and Business Teams for requirement gathering.
• Designing Dimension and Fact tables based on the requirements and specifications.
• Developed different types of SSRS reports like Linked Reports, Sub Reports and Drilldown Reports.
• Developed Expressions in reports to control content and report appearance by using Report Functions.
• Deployed the reports to the Report Manager by applying the specified Security settings. the end users to run and export the reports using the Report Manager
• Reduced manual effort/hours by developing SSIS packages to automate the process of importing data from external interfaces (Excel, CSV, Text files) to Dim/Fact tables
• Creating SSRS reports that use Cubes as data sources
• Developed Multidimensional Expressions (MDX) to retrieve data from SSAS cubes.
• Created Stored Procedures, User defined Functions, Triggers, custom views and TSQL Scripts in SQL server database.
• Analyzed and optimized existing stored procedures and functions leading to performance improvement and faster payment processing.
• Designed and Developed applications in C# 3.0 to monitor folders and start SSIS packages.
• Worked on project to upgrade SQL Server 2005 to SQL Server 2008.
• Conducted session with product support team before all releases help them in handling trackit’s.
• Perform code reviews for peers.
• Used Sybase power designer for data modeling.

Environment: MS SQL Server 2000,2005,2008R2,2012 SQL Agent, SQL Profiler, Windows2003, 2008 server, VMware.

Confidential, Cincinnati, Ohio

MS SQL Server / SSIS / SSRS Developer

Responsibilities:

• Working with business for collecting the proper requirement to implement in development phase and validate it by business approval
• Have a discussion with business for tracking of the requirement on weekly basis to distribute the task by team wise
• Involved in trouble shooting for finding solutions in team
• Data migration from existing old system to new Confidential system
• Working on Agile project to attend the daily stand up meeting to update the status on every day.
• Data synchronization across all the environment and Systems with SQL script.
• Involved in report requirement analysis, and Design
• Creating ETL with SSIS to extract data from RDBMS, Excel and CSV, perform business logic and Load data into Excel, Text or RBDMS Destinations.
• Deployment of all the SSIS packages across environment TEST, QA and Production.
• Scheduling of SSIS Package to execute daily, weekly or monthly.
• Creating reports in SSRS and providing to business as per requirement.
• Developed complex SSRS reports
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Configure the SSIS Package for run time Parameters and Config file

Environment: Microsoft SQL Server R 2 /200.8/2005 , Windows 2008, SSIS, SSRS, Qlik View.

Confidential, West flake village, CA

SQL Server Developer

Responsibilities:

• Actively participated in understanding of business requirements and creating technical specifications with business analyst, project manager, and end users.
• Identified the data source and defining them to build the data source views. Developed invalid data identification process using pattern matching and automated their correction by defined business logics using SQL stored procedures and user defined functions
• Wrote extensive data transformation process driven by mapping SQL tables using SQL routines in SSIS package tasks.
• Designed and implemented tables, functions, stored procedures in SQL Server.
• Created database objects like tables, views, indexes etc. Created and modified stored-procedures, cursors
• Creates packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Pivot and Union all.
• Created SSRS reports and hosting it in the web for the users. Created data dictionary and well documented all SQL processes for future and support.
• Used execution plan to analyze stored procedure and individual SQL query to identify performance pitfall and tuned them by creating indexes, updating statistics, removing correlated sub-queries, and strategically de-normalizing SQL tables.
• Optimized data load process using bulk load method, and multiple threads for parallel loading and Created data dictionary and well documented all SQL processes for future and support.
• Ensure to adopt Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: MS SQL Server 2008, MS SQL Server Reporting Services 2008,XML, MS SQL Server Integration Services, Windows XP.

Confidential, Chicago, IL

Microsoft SQL Server Developer

Responsibilities:

• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly and Created crystal reports and hosting it in the web for the users.
• Developed complex T-SQL code for the application. Worked in Reporting Manager for job scheduling and batch queries. Planned Backup strategy based on projects requirements
• Monitored performance and optimized SQL queries for maximum efficiency.
• Implemented fine tuning of database objects and server to ensure efficient data retrieval.
• Responsible for deploying the generated reports on the production environment after validating them in the QA environment and Debug the reports using Stored Procedures
• Reviewed and analyzed technical and application related problems. Identified the data source and defining them to build the data source views
• Involved with DBA for the maintenance of database and implementation Snapshot Replication. Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Scheduled Job and alerts. Designed and implemented user log in and security.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005, Oracle 8i, Windows XP.

Confidential

SQL Developer

Responsibilities:

• Load the data into fact tables by using SSIS
• Clean the data by using different SSIS transformations Develop cubes by using SQL Server Analysis Services
• Write MDX Queries
• Partition the fact tables using 2005 Partition Function base on Month id, total 12 partitions
• Implemented different types of dimensions in SSAS cubes:
• Role-Play dimensions
• Confirmed dimensions
• Slowly changing dimensions
• Junk dimensions
• Use SCD transformation to populate the Dimension tables
• Create SSRS subscription and cache reports
• Slice and dice SSAS cubes data based on LTV, credit history, loan type and provider
• Development SSRS reports ranging from extracts of simple datasets to complex, graphical including drilldown reports, drill-through reports, sub-reports and linked report
• Strong working knowledge of database design fundamentals
• Mappings across all banking data sets, including market data, deal transaction workflows, and CRM data.
• Strong understanding of ETL principles such as meta-driven ETL, table driven business rules, and dimensional modeling

Environment: MS BI (SSIS), SQL Server 2005, c#, MS SSAS and SSRS reports