SUMMARY

• 7+ years of experience in design, development and implementation of business requirements with SQL Serve 2008/2005/2000 database system and Microsoft .NET framework as front end in the client/server environment as SQL Server / Business Intelligence Developer across various sectors including Telecom, Finance, Retail and Health Care.
• Expertise in Financial, Manufacturing and Insurance Domains.
• Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS 2008/2005and SSRS 2008/2005.
• Expert in designing and implementing enterprise level ETL strategy using SSIS 2008/2005, MS DTS, which includes homogenous and heterogeneous data, sources.
• Experience in upgrading SSIS 2005 to SSIS 2008 packages and converting MS DTS packages to SSIS 2005 packages.
• Implemented best practices in developing SSIS packages for better performance.
• Experience in report generation using Crystal Reports, SQL Server Reporting Services and Excel spreadsheet as per the requirement and for the periodic analysis.
• Developing reports using SQL Server reporting services (SSRS) from a variety of data sources including analysis data cubes and external databases.
• Experience in creating Cross - tab, Conditional, Drill-down, Summary, OLAP, Sub reports and Parameter prompts using Crystal XI.
• Proficient in implementing business logic and process in backend using stored procedures, Functions, Triggers, Views, Complex queries on SQL Server 2008/2005/2000 using T-SQL.
• Expert in tuning database by choosing indexes and using tools Database engine tuning advisor, SQL Profiler.
• Working knowledge in Data warehouse (OLAP), Snowflake Schema, Star schema, Fact Tables, Dimensions and Cubes.
• Thorough understanding of BI concepts, Kimball/Inman strategies.
• Exposed to all phases of software development life cycle (SDLC) including in-depth knowledge agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem management and escalation procedures.
• Excellent teamwork spirit and capable of learning new technologies and concepts.
• Worked on Development/Staging/Production Environment and used team Foundation server/Visual Source safe for version controls and communications well as defining actions, translations and Perspectives.
• Have demonstrated outstanding leadership, creative problem solving and analytical skills in the areas of developing Business Intelligence (BI) functionality incorporating assorted tools and worked with several groups across multiple platforms.

TECHNICAL SKILLS

Operating Systems: Windows NT, Windows 95-98, Windows XP, Windows 2000, 2003, MSDOS, UNIX

Database/Database Tools: Microsoft SQL Server 2000/2005/2008 R2/2012, MS Access 97/2000/2003/2007 , Oracle 8.0/10g, ADO, ADO.Net, OLEDB, ODBC, Teradata SQL Assistant, Teradata Manager

Languages: SQL Programming, Visual Basic 6.0, Visual Basic .Net (2003 -2005), VBA for Excel, ASP.Net, ASP, HTML, XML, C, C++, TSQL, PL/SQL, WMI Programming

ETL/Data Warehouse: DTS (Data Transformation Services), SSIS (SQL Server Integration Services)

OLAP: SSAS (SQL Server Analysis Services)

Reporting: SSRS (SQL Server Reporting Services), Crystal Reports, Business Objects

Scripting: VBScript, Java Script

SQL Backup Tools: SQL Litespeed, Red Gate

Web Technologies: ASP.NET, Java Script, HTM

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

SSIS/SSRS Developer

Responsibilities:

• Involved in gathering Requirement and designed the logical modeling and physical modeling for OLTP application.
• Created database objects such as Tables, Views, Stored Procedures, Triggers, Indexes and functions.
• Implemented complex business logic with Stored Procedures, User Defined Functions, Views and wrote T SQL batches with CTE for Recursive operations.
• Wrote DML Operations for OLTP systems using TSQL, Dynamic TSQL.
• Designed the number of SSIS packages for data transfer between flat files, XML, Oracle, MYSQL and SQL Server using different Transformation.
• Created SSIS Template for developing SSIS packages, Implemented SQL Server configurations and error handling in SSIS Packages.
• Prepared the reports to show ineligible loans, total loans securitized etc. on day-to-day as well as weekly/monthly purposes using SSRS 2008 and scheduled them.
• Developed SQL queries for generating drill drown reports in SSRS and Adhoc reports through report builder.
• Scheduled theSSISpackages to run as jobs on periodic basis according to the requirement using SQLServer Agent.
• Worked with team of technical staff and business managers and practitioners in the business unit to determine systems requirements and functionalities needed in large/complex development project.
• Ability to analyze and resolve performance issue with database code involvingSSISand MSSQL Server 2005/2008.
• Developed Database triggers and User defined functions to meet the business requirements using T-SQL.

Environment: MS SQL Server 2000/2005/2008 , MSSQLServer 2008 R2, Visual studio 2008,SSIS, SSRS, JIRA MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS),T-SQL, PL/SQL, Visual Studio 2005, BIDS, Windows 2003/2008 Server.

Confidential, Atlanta, GA

SSIS/SSRS Developer

Responsibilities:

• Designed and implemented ETL to automate Sales and Campaign data load and set email notifications to send status of the load usingSSIS.
• Developed back end stored procedures to implement search logic to support the Campaign data Search from front end web application. Coordinated with front enddevelopersregarding input validation criteria.
• Developed C# programs to automate the refresh of the reports based on MS Excel and used them for Script Task.
• Worked on gathering requirements to design automated process to load sales partners call data.
• Worked closely with dba team to understand auditing and logging standards to implement in developing automated process to load sales partners call data.
• ImplementedSSISpackages to load sales partner call data and scheduled the jobs.
• Automated the process of downloading data files that company receives from vendor FTP/SFTP servers on regular basis and logged the file metrics.
• Developed SSRS reports to display metadata of several data feeds.
• Developed Database triggers and User defined functions to meet the business requirements using T-SQL.
• Implemented business rules using stored procedures to achieve best performance.
• Implemented data security by automating the process of logging user login times usingSSISand developed a SSRS report to filter the data.
• Wrote and integrated Stored Procedures to generate the Reports like Matrix Reports, Reports with multi valued parameters, drill- down reports, Top N reports and reports with running totals, reports with interactive sorting using SSRS to show calls and sales activity by the representatives.
• Creation, Implementation and Administration of the Database (Backup & Recovery). Tuning of SQL Server Configuration (Locks, and Indexes). Administering SQL Server 2000/2005/2008 Replication Model, Linked Server & Server Security
• Involved in Implementation and Maintenance of Disaster Recovery solutions such as Replication and Log Shipping.
• Fine-tuned SQL Queries for maximum efficiency and performance. Generated necessary documentation through MS Word and Flow charts with MS Visio. Generated SQLfor views from query subjects in Framework model. Designed and implemented Stored Procedures for automating tasks

Environment: MS SQL Server 2000/2005/2008 , MSSQLServer 2008 R2, Visual studio 2008,SSIS, SSRS, JIRA,MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), T-SQL, PL/SQL, Visual Studio 2005, BIDS, Windows 2003/2008 Server.

Confidential, Arlington, VA

SQL Server Developer

Responsibilities:

• Gathered Requirements and Design the Technical documentation.
• Worked with all the stakeholders of the project to understand the business requirement.
• Prepared Visio diagrams to show the blueprint of the dataflow.
• Designed and ProgrammedSSISpackages for the initial seeding load and subsequent detail loads of the Data mart.
• Built efficientSSISpackages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
• Implemented configurations inSSISpackages to make them portable. Handled the exceptions and error logging.
• Performed Unit testing and integration testing of developedSSISpackages.
• Coordinated with source system people to schedule the Jobs for data mart loads.
• Implemented business logic using T-SQLprogramming and new features inSQLServer 2008.
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Used Report Builder to do Ad-hoc Reporting.
• Configured and maintained Report Manager and Report Server for SSRS
• Migration of MS Access Reports to SSRS environment.
• Design, create and manage multidimensional structures using SSAS.
• Used Upgrade Advisor to analyze the changes required in existing version (SQLServer 2005) and made necessary code changes to accommodate backward compatibility.
• Converted the reports developed using Actuate to SSRS reports.
• Modified the fields and Layout of the reports according to change in the requirement.
• Coordinated with reports users to get Sign off for new reports and got them uploaded to Production Portal.
• Worked on query tuning and optimizing database code and developing batch-processing jobs.
• Developed Unit test cases and perform Unit testing of assigned components on Test Data.
• Developed processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
• Lead Developer and managed 2 people in migrating DTS Packages. Created databases and objects as Per the Project Need and Imported and Exported data to SQL server databases from text files using DTS, Copied databases from one Machine to another using Backup and Restore.
• Created Linked Server, gave permissions to access the server.

Environment: MS SQL Server 2000/2005/2008 , T-SQL, PL/SQL, Visual Studio 2005,Server 2005/2008, Visual Studio 2008,SSIS, SSRS, BIDS, Maestro

Confidential

SQL Server Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation.
• Designed the ETL process based on the schemas (snow flake and star schema) for extraction and transformation of data from the source database and loading on to the target database.
• Supported the Capital Markets Technology Applications specifically application related pricing, hedging and securitization of Mortgages as well as applications related to income forecasting.
• Worked with team of technical staff and business managers and practitioners in the business unit to determine systems requirements and functionalities needed in large/complex development project.
• Designed ETL strategies using Visio showing Data Flow to peerdevelopersand Lead.
• Implemented ETL usingSSIS2008 to perform Loan data flow to the system from heterogeneous sources like Excel Spreadsheet, Flat files, XML documents residing in FTP locations.
• Implemented complex business rules using multiple transformations like Conditional Split, Look up Transform, Derived Column, and Union All. Also, handled errors efficiently.
• Scheduled theSSISpackages to run as jobs on periodic basis according to the requirement using SQLServer Agent.
• ConfiguredSSISpackages to move the same between different Environments and for optimal performance.
• Designed error tolerantSSISpackages and logged the execution details.
• Work directly with users and business partners to gather reporting requirements and provide solutions.
• Prepared documents to show the details of packages and Reports created for future reference.
• Prepared the reports to show ineligible loans, total loans securitized etc. on day-to-day as well as weekly/monthly purposes using SSRS 2008 and scheduled them.
• Implemented the core business process using T-SQL, Stored Procedures and Functions.
• Developed code, perform reviews to advance application upgrade, extension, or other development. Analyze application for data integrity issues.
• Ability to analyze and resolve performance issue with database code involvingSSISand MSSQL Server 2005/2008.
• Responsibility as a Tier-3 Primary during the production support for applications as on needed basis.
• Knowledge of financial instruments such as Mortgage, bonds, MBS etc.
• Implemented Source Control using Team Foundation Server.
• Work closely with business stakeholders, business analyst, and production teams across functional units to identify business needs and discuss solution options.
• Designed and developed Complex Queries, T-SQL Stored Procedures, Triggers, Tables, Constraints, Views, and Functions in MS-SQL Server 2000/2005.
• Responsible for designing and developing a Drill Down, Cross-tab, and Tabular Report using Report Server in SSRS to draw data from the Data Warehouse. Periodically developed a Report to be used by the Senior Management utilizing SSRS.

Environment: MS SQL Server 2000/2005/2008 , MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), T-SQL, Visual Studio 2005, BIDS, Windows 2003/2008 Server.