PROFESSIONAL SUMMARY:

• More than 7 years of Professional experience in IT industry as a SQL Server /BI developer /Data Modeler
• Microsoft certified technology specialist (MCTS) and certified information technology professional (MCITP) in sql server 2005
• Microsoft certified technology specialist MCTS for business intelligence
• Experience in Fine Tuning SQL queries and T-SQL queries & improving the performance of the Database.
• Information gathering, analyzing the information gathered, documenting the functional or business requirements
• Good SQL Server 2000/2005/2008 Administration skills including user authorizations, Database creation, backup, restore, replication, scheduling and clustering.
• Upgrading data to recent versions from earlier versions using MS Access, SQL server
• Experience in Database Development and Data modeling such as Creation of Tables, Stored Procedures, Triggers, Views and Functions using Transact-SQL.
• Experienced in using Data Modeling tools like Visual Studio, ERWIN, Ms-Visio
• Extensively used crystal reports, atuate reports, SSRS to generate reports based on the client needs
• Experienced in building up dashboards using MOSS 2007 and knowledge on performance point
• Extensively involved in data extraction and loading using DTS in MS SQL Server 2000 and SSIS in MS SQL Server 2005. Import Export data, Bulk Insert and BCP. .
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.
• Experienced in converting crystal reports, actuate reports to SQL reports
• Experience in Data Conversion and Data Migration from earlier versions to current sql server using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Extensive exposure in SSIS, SSRS and SSAS and charting tools like graphical charting
• Good knowledge of share point 2007 in managing documents creating workspaces. Exposure towards moss 2007 and performance point.
• Knowledge on MES, TFS, MDX, Replication understanding C#, .net(validated applications using asp.net) concepts
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

Operating Systems:

Windows 2003 / NT / XP/ME/9.X, UNIX (Solaris 8.0/9.0)

Languages:

C, C++, JAVA, VB 6.0, T-SQL, java/vb script

Web Technologies:

HTML, WML, XML

Databases:

MS SQL SERVER 2005 / 2000 / 7.0, MS Access 2003, ORACLE 8.x

Packages:

MS Office 2005, MS Visio, Visual studio, MOSS 2007, ERWIN,CSS

Testing:

Win Runner, Load Runner

ETL tools:

DTS, SSIS, SSAS, SSRS, Informatica, proclarrity, Crystal Report 9/11

Database Tools:

SQL Enterprise Manager, SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Agents, SQL Alerts, SQL Mail, SQL Client Configuration utility, Backup Server, Replication server, OLAP Services, Replication Tools

• Bachelor’s in Information Technology
• Microsoft certified technology specialist (MCTS) in SQL SERVER 2005
• Microsoft certified in designing database solutions using SQL SERVER 2005
• Microsoft certified in designing and optimizing using SQL SERVER 2005
• Microsoft certified (MCTS) in SQL SERVER 2005 Business Intelligence
• Certificate of Appreciation

Confidential,West Chester, PA Sept 2009-Till date
Sql Server Developer
Client Description:
Confidential,is an American company that specializes in making insulin pumps, used by people with diabetes. The company was acquired by Johnson & Johnson on February 18, 2006. It is headquartered in West Chester, Pennsylvania and forms part of the Johnson & Johnson Diabetes Franchise along with Life scan and several other companies serving the needs of people with diabetes.
Project Name: Synchronicity
Responsibilities:

• Created new Tables, Stored Procedures and Functions as per the technical document
• To establish a single process and application that supports the process for complaint capture, product analysis, and vigilance reporting, and trending at a franchise level
• Worked with business users to define and analyze problems, create logical data model, implement physical data model, and the implications of business solutions to the current and future environment
• Worked with Ms-access, Cognos to create and modify the existing reports
• Identified new process, finding out gaps in existing process, arranging training modules for new process development and implementation
• Implemented Normalized database from scratch, Using Stored Procedures and SSIS Packages
• Took part in the meetings with Business Analyst and managers and understood various process plans, business process, and functionality in detail
• Designed Interface Stored Procedure to accomplish the Synch between two Systems Via Web Methods
• Used DTS to migrate the legacy date, SSIS to transfer data between different Servers
• Designed and automated different types of reports using SSRS
• Dealt with data-driven Subscription and created subscriptions, as per business request
• Modified existing Stored Procedures as per new business requirements
• Increased the performance of existing Stored Procedures by converting into batch from cursor
• Used lock hints like nolock, Xlock for better performance and efficiency
• Create joins and sub-queries for queries involving multiple tables
• Data migration using ETL scripts, in order to create a complete new environment to avoid the discrepancies while doing reporting

Environment: SQL Server, SSRS, SSIS, DTS, MS-Visio, Ms-Access, Erwin

Confidential,Torrance, CA July’2009–sept 2009
SQL Server Developer
Confidential,is a global nutrition, weight-loss and skin-care company. The company distributes its products in 70 countries through millions of independent distributors.
Responsibilities:

• Created new Tables, Stored Procedures and Functions as per the technical document
• Modified existing Stored Procedures as per new business requirements
• Increased the performance of existing Stored Procedures by converting into batch from cursor
• Used lock hints like nolock, Xlock for better performance and efficiency
• Create joins and sub-queries for queries involving multiple tables
• Created format files to support bop transformation in SSIS via FTP
• Worked on SSRS to handle ad-hoc requests
• Used SSIS to transform data into SQL database via FTP from Text files, MS Excel as source
• Used SSIS packages to load date from spreadsheet into the database and also used packages to move data between databases(oracle, flat-files) on different servers
• Used SMA job scheduler to schedule jobs as advised by the business user
• Supported the QA team during the testing phase

Environment: SQL Server, SSRS, SSIS, Visual Studio 2005, Quality Center, Vault, Primavera, Erwin 4.1

Confidential,Columbus, OHIO Jan ‘09 – July’09
SQL developer/BI developer
Reporting and analysis of Healthcare Data
Confidential,is the insurance for the Medicaid and Medicare for the low income people, claiming premium from State Tax, as a BI Developer, We worked on building reports using SSRS and integrated SSRS with SharePoint.
Responsibilities:

• Automation of reports using SSRS through stored procedures and parameters
• Implemented generic-level security by generating reports from views
• Generated Reports required by the users, which includes table, matrix, chart, Document Maps
• Designed reports from scratch involving drilled-down and drilled through reports and sub-reports
• Generated Report model so that the users can develop their own projects using report wizard
• Developed stored procedures with complex calculations and nested joins from different tables within a single and more databases with the help of linked server
• Integrated report manager with SharePoint in Naïve mode, eliminating the first layer of security to the report manager
• Used ProClarity as the reporting and analyzing tool as a Dashboard for the cube structures
• Assisted fellow developers with OLAP and Doing ETL in transformation of cubes
• Designed various Star schema as directed by the management for different departments and contributed towards building up Data mart
• Assisted in migrating cubes from 2000 to Sql server 2005 using SSIS
• Used SSIS packages to load date from spreadsheet into the data base and also used packages to move data between databases(oracle, flat-files) on different servers
• Migrated reports from crystal and MS Access to SSRS and scheduled them appropriately (Daily, Weekly, Monthly etc)

Environment: MS SQL Server 2005, Erwin, SSIS, SSRS, SSAS, Proclarity, Visual Studio, MOSS 2007

Confidential,Cincinnati, OHIO Jun ‘08 – Nov’08
MS SQL Developer
Freight Re-alocation
Confidential,is one of the leading providers of banana, salads and fruits across the world. As a consultant at Confidential, worked on stored proc to re-calculate the freight data to pull the historical data from JDE into for the Data warehouse and helped to use informatica in transforming the data into the warehouse
Responsibilities:

• Create new tables, views, indexes and user defined functions.
• Extensively dealt with ETL and worked with the DBA to fasten certain SSIS packages and SP.
• Involved in performance tuning of T-SQL queries and worked with nested Stored Procedures.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create freight re-allocation strategy.
• Modified existing stored procedures written in pl/sql as per the business logic
• Created reports using SQL SERVER 2005(SSRS) and Involved in generating Matrix reports, Sub reports and complex reports
• Create reports in SQL server using SSRS as per the requirements provided by the Front End users.
• Used SSIS to transform data into SQL database from Text files, MS Excel, Oracle as source
• Heavily worked with temp tables, Lookup tables. Temp and global variables to design the stored procedure
• Involved in moving data between servers using SSIS, generated reports as required by the end users

Environment: MS SQL Server 2005, T-SQL, ETL/SSIS, SSRS. INFORMATICA, Erwin 4.1, Oracle

Confidential,Cleveland, Ohio Feb ‘07 – Apr’ 08
MS SQL Developer
Human Resource Management System
Confidential, is one of the leading providers of auto, home and life insurance in the United States. As a consultant at QualChoice for the Human Resource Management System (HRMS), part of an ERP (Enterprise Resource Planning), developed and helped to implement HRMS that is designed to handle the human resource activities for the organization. HRMS is a web based three-tier architecture system which provides information about employee data, new hire, applicants, promotion, demotion, leave or absence, payroll data, and change of certain business rules required development of new modules to the system.
Responsibilities:

• Actively designed the database to fasten certain daily jobs and some stored procedure.
• Optimized query performance by creating indexes.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Worked with Data modeling team to design physical model of the database
• Data migration from EXCEL, MS Access to SQL Server
• Responsible for working with co-developers in designing packages in SSIS/ETL
• Created the SSIS packages to pull the data from two sources (OutlookSoft, text) and Publish them into Database
• Assisted fellow developers with OLAP and Doing ETL in transformation of cubes
• Created Drill report which give all the details of various transactions like closed transactions, pending approvals, summary of transactions and scheduled this report to run on quarterly basis
• Create reports in SQL server using SSRS as per the requirements provided by the Front End users.

Environment: MS SQL Server 2005, T-SQL, Visual Studio, ERWIN, crystal reports 11, ETL, OLAP

MS SQL Developer
Sales report Data Mart
Responsibilities:

• Gathered the requirements from the client and translated the business design into Technical Design
• Prepared a database design document based on the functional and technical specifications
• Supported OLAP team to providing data from SQL Servers and generating reports
• Used MOSS 2007 as dashboard to deploy the reports and cubes for the user interaction
• Scheduled DTS packages and services to run at different intervals in SQL Server that are ideal for developing custom ETL routines for populating decision support databases using ODBC
• Coded stored procedures, Functions, Triggers and SQL scripts at high level

Environment: SQL Server2000/2005, Windows XP, Informatica MOSS 2007, Erwin 4.1, MOSS 2007

Confidential,Milford, CT Mar’ 05 - Feb‘06
MS SQL Server Developer
Security monitor application
Environment:MS SQL Server 2000/7.0, Crystal reports, .Net, Visual Basic 6.0, T-SQL

Confidential,Chennai, India July ‘02 - Dec‘04
MS SQL Server DBA/Developer, Trainee
Customer Loan processing System
Environment: SQL Server 2000/7.0, T-SQL, Microsoft VC++, Windows 2003 Server, VB.net