SUMMARY

• Around 8 years of extensive experience in database activities like Data Modeling, Database Design and Development, Coding, Implementation, Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication on Windows environment.
• Experience in Analysis, Design, Documentation, Development, Testing and Implementation in Client/Server applications using Confidential SQL Server 2005/2008/2012 and BI Suite for various Business, Finance and Health care domains.
• Expertise in Relational Database Management Systems using SQL Server 2000/2005/2008/2012.
• Proficient in Database Programming and Development using SQL Server and good experience in creating T - SQL (DDL, DML), Triggers, Views, User Defined Functions and Complex Stored Procedures.
• Expertise in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2008 with Import/Export data, Bulk insert and BCP.
• Experience in SQL Server 2005 OLAP database development including KPIs, Data Mining, working with slowly changing dimensions (SCD).
• Expert in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
• Expert in Confidential SharePoint Server and IIS web server to produce sites for file sharing, web databases and web publishing.
• Supported team in resolving SQL Reporting services and T-SQL related issues and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Sub reports and formatting them.
• Expert in using different Recovery Models simple, full and bulk-logged depending on availability of database.
• Proficient in creating logical and physical data models using Erwin data modeling tool.
• Managed full life cycle Custom Development for several business applications from inception to completion.
• Ability to quickly learn and adapt to teh rapidly changing Internet economy.
• Been involved in Agile practices such as daily scrum and sprint planning
• In-depth knowledge in Object Oriented Concepts and experience in OOAD Technologies, developing Use Cases, Activity diagrams, Sequence Diagrams and Class Diagrams using case tools like Rational Rose.

TECHNICAL SKILLS

• MS SQL Server
• Confidential Visual Studio 2010
• Confidential Integration services 2010/2008/2005
• Windows 2000/2003 Advanced Server
• Windows Exchange Server 2003
• Windows NT 4.0/3.5
• Windows9.x
• Windows XP
• MS-Access
• Oracle8.me
• Oracle 9.me
• T-SQL
• XML
• MS Visual studio 2005
• ERWIN 7.1
• Confidential SharePoint
• Confidential Visio 2003

PROFESSIONAL EXPERIENCE

Confidential, Virginia Beach, VA

MS SQL SERVER/SSIS/SSRS Developer

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, MS Excel, Oracle 11g.

Responsibilities:

• Gathering requirements from users and creating code design documents.
• Working with higher level management to acquire requirements.
• Creating SSRS 2008 Reports which are parameterized.
• Creating data driven subscriptions to teh reports.
• Work with right fax to fax teh reports to teh facilities.
• Created .NET code to generate control files which are used to send faxes through right fax.
• Worked on loading of Authorizations into FACETS schema in Oracle databases.
• Created SSIS Packages to perform ETL operations on files received from third party vendors to load into FACETS schema.
• Worked on logging, scheduling, configuring SSIS packages.
• Worked on generating response files to be sent back to different third party vendors for teh input files received.
• Worked on loading Flat Files, Excel Files into tables.
• Created database objects like tables, procedures, indexes and functions in both Oracle and SQL Server databases.
• Worked on fine tuning queries using execution plans.
• Created SSIS Configurations using XML Configuration and OLEDB Configuration.
• Scheduled jobs using TIDAL. Deployed SSIS Packages and Config’s using in house built tools to QA and Prod environments.
• Worked with JIRA to monitor tasks assigned and completed.
• Deployment of reports and working on production fixes for them.
• Working on tight schedules for deliverables and delivering teh solution.

Confidential, Chicago, IL

MS SQL SERVER/SSIS Developer

Environment: MS SQL Server 2008/2012, SQL Server Reporting Services 2012, SQL Server Integration Services 2008/2012, MS Excel, Oracle 11g.

Responsibilities:

• Migrating Data from Oracle to SQL Server Using SSIS.
• Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views for new and existing applications.
• DesignedSSIS packages to Extract data from different sources like SQL server 2008, MS Access, Oracle 11g and transform and tan load intoDimension and Fact tables in Data Warehouse using SSIS
• Load Data from different sources to support applications like I2B2, which in turn help researchers to lookup data.
• Tuned several slow running queries in Production. Implemented Indexes to achieve time performance.
• Used config files in SSIS to ease teh process of moving teh packages across servers (development to production)
• Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
• Designed, developed, modified and enhanced teh database structures and database objects.
• Used conditional formatting to change teh behavior of teh report depending upon teh requirement.
• Debugged and deployed reports in SSRS.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Scheduled and monitored SSIS Packages using bat files and Visual Cron Job Scheduler.
• Generated various Report models on Views (due to security issues) and deployed them on to teh production reporting server and generated various Report models and ad-hoc reports.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format teh contents of teh report according to teh requirement.
• Created standard report Subscriptions and Data Driven report Subscriptions
• Created several SSIS packages in Confidential SQL Server 2012.
• Transferred data into various formatted files and immediately updated my managers with teh automated email systems.
• Used Confidential SharePoint Server to provide a framework for web application development.
• Optimized queries by looking at Execution Plan for better tuning of teh database.

Confidential, Overland Park, KS

MS SQL SERVER Developer/MS Business Intelligence Developer

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, MS Excel, MS Windows Server 2003, Oracle 10g/9i.,Team Foundation Server 2010

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on teh given specs and requirements.
• Developed Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain teh required results.
• Bulk data migration using SSIS from flat files.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS using various features like data conversion etc. Created derived columns from teh present columns for teh given requirements.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS packages and scheduled them as jobs to run automatically to Process teh cube, load data etc.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Developed different Parameterized Reports, which consist of, report Criteria in various reports to make minimize teh report execution time and to limit teh no of records required.
• Report parameters included single valued parameters, multi-value parameters dat also consist of different parameter types like hidden, internal, default (queried and non queried parameters).
• Developed teh packages with monitoring features and logging so dat audit information of teh packages and their execution results are loaded in to teh audit table.
• Used Team Foundation Server (TFS 2010) to track teh changes in code.
• Used Environment variables to configure teh SSIS packages.

Confidential, Chicago, IL

MS SQL SERVER Developer/MS Business Intelligence Developer

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2005/2008, SQL Server Integration Services 2005/2008, MS Excel, MS Windows Server 2003, Oracle 10g/9i.

Responsibilities:

• Database planning in relation to physical and logical data architecture.
• Worked with XML files to load them into database using SSIS packages and XSD’s. Also worked with teh XML’s to bulk load-using XQuery.
• Used Batch files to schedule teh SSIS Packages built in teh environment.
• Built SSIS Packages for smooth running of Interfaces necessary for teh new application.
• Created Configuration Files and implemented Error Handling to support teh SSIS Packages.
• Worked with multiple scripts optimizing them for smooth transition of data from old legacy system to new application
• Deployed database objects and SSIS packages into production.
• Worked with scripts for Performance Tuning by Indexing of teh tables.
• Created Complex Stored Procedures, Triggers, Tables and other database objects for supporting teh SSIS Packages and application.
• Created SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Worked through successful implementation of Packages by testing them and moving them to production.
• Interacted with end users to understand teh business requirements and implemented those in teh interfaces.
• Worked with cleaning of data by analyzing to successfully migrate teh existing data to new database.
• Worked with multiple databases me.e. SQL Server and Oracle for teh migration of databases from old system to new system.
• Setup Interfaces to automate and generate reports to User accessible locations on a daily basis.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Assisted in setting up teh new application on teh application server and worked to implement LDAP and SSO for TEMPeffective functioning of teh application.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technical leads for resolution of technical issues.
• Automating and Daily monitoring of jobs, figuring out errors and solving any Blocking issues dat arise

Confidential, Redmond, WA

MS SQL SERVER Developer/MS Business Intelligence Developer

Environment: MS SQL Server 2012/2008/2008 R2,SQL server Reporting Services 2008, SQL Integration Services 2008, Confidential Visual Studio 2010, SQL Server Management Studio, MS Excel, T-SQL, ERWIN.

Responsibilities:

• Analyzed business requirements and build logical data models dat describe all teh data and relationships between teh data.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
• Worked in Agile Environment and attended daily scrum meetings.
• Was actively involved in sprint planning to make sure they are minimum carryovers.
• Deploying new Database objects in production environment.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Wrote MDX queries to query data from cubes to teh report.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize teh report execution time and to limit teh no of records required.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Testing and loading teh data on Development and Production.
• Managing teh use of disk space, memory and connections.
• Running DBCC consistency checks, and fixing data corruption in application databases
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
• Checked Performance Tuning, Indexing, Query Optimization.
• Worked with project manager and technical leads for resolution of technical issues.
• Create reports based on data analysis and provide Heat-Mapping and Indicators in reports to help in TEMPeffective handling of fraudulent activity.
• Created UDF’s, triggers, Stored Procedures for maintaining real-time servers which has 3 months’ worth of data which pull data from data warehouse.
• Created Indexes, both clustered and non-clustered for improving in performance as teh tables contain huge pile of data.
• Monitoring jobs to pull huge data into real-time server for analysis purposes.
• Attending meeting with clients and upgrading and handling existing reports based on end-user requirements.
• Carried out migration to a secure sandbox environment and implementing security levels, encryption and certification on teh server to ensure safety to sensitive data.
• Created cube for daily calculations of customer feedback based on different attributes and figuring out teh satisfaction of customer and time and money spent on handling teh call.
• Created multiple SSIS packages and deployed them to pull in data from 5 different sources regularly and use stored procedures for modifications in data and obtained derived tables to be used in reports.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Added filters, columns, parameters, color coding to existing reports for user - friendliness.
• Monitored report manager granting access to end users based on level they need to look data at and providing teh end-user with a clean and easily understood user-interface.

Confidential, Philadelphia, PA

MS SQL SERVER Developer/MS Business Intelligence Developer

Environment: MS SQL Server 2008, SQL Server Reporting Services, T-SQL, SQL Server Integration Services, MS Access, MS Excel, MS share point services

Responsibilities:

• Created Star schema dimension modeling for teh data mart using Visio and created dimension and fact tables based on teh business requirement.
• Gathered report requirements and determined teh best solution to provide teh results in either a Reporting Services report, Analytical Cube or an Excel pivot table
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into teh SQL table
• Produced operational reports in SSRS 2008 me.e. drill-down, drill-through, dashboard and matrix reports.
• Developed SSAS Cubes for building reports using SQL Server Business Intelligence Development Studio to support reporting and forecasting processes
• Wrote complex SQL queries and stored procedure to create reports using SSRS 2008 from teh relational database and OLAP as SSAS 2008 source
• Generated monthly and quarterly reports as bar charts for teh management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Converted manual reports pasted together into parameter driven stored procedures to be used with Confidential Reporting Services 2008
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
• Developed functional and technical documentation to assist in teh design, development and/or maintenance of deliverables
• Created SSRS Data Model projects using Confidential Visual Studio 2008 and using Report Builder for report server to create reports
• Configured teh report server and generated teh report models for user interactions
• Responded to ad hoc requests and special projects dat require immediate attention while at teh same time maintaining deadlines on existing requests.

Confidential, Cypress, CA

MS SQL Server/SSRS/ SSIS Developer

Environment: MS SQL Server 2005/2008, MS SQL Server reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), T-SQL, SQL Server Query Analyzer, Visual Studio, Windows XP, Window Server 2003/2008.

Responsibilities:

• Installed, upgraded and migrated databases from Oracle database to MS SQL Server 2005/2008.
• Created business process diagrams defining current business processes.
• Generated reports using MS SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Developed ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2005 SSRS.
• Constructed teh OLAP cube using SSAS and used SSIS to transform teh data into OLAP.
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions for data migration. Involved in teh project from planning stage to pushing codes to production.
• Designed ER diagrams and mapped teh data into database objects and performed normalization of teh database in OLTP.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agentusing SSAS.
• Wrote MDX scripts to create name sets and calculated members and created reports by dragging data from cube in SSAS.
• Worked as a technical expert in teh design, development, and maintenance of OLAP cubes and databases
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005.
• Performed system study and requirements analysis, prepared data flow diagrams, entity relationship diagrams, data diagrams, and table structures to store teh data.
• Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean teh old data and also helped teh front end application developers with their queries.
• Designed and created different ETL packages using SSIS and transferred data from Oracle source to MS SQL server destination.
• Performance tuning of SQL queries and stored procedures using SQL profiler and index tuning advisor.
• Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries.
• Used business object tools to develop reports and accessed, formatted, and delivered information to large populations of users.
• Developed complex reports using multiple data providers, user defined objects, charts, synchronized queries, and created star schema in SSAS to develop ad-hoc reports for teh clients as per their requirements using SSRS in MS SQL 2008.

Confidential

SQL Server Developer

Environment: Confidential SQL Server 2000, Sql Server Integration Services, SQL Server Reporting Server, T-SQL, SQL Profiler

Responsibilities:

• Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.
• Part of team for analyzing and implementing teh physical design for teh database.
• Responsible for drafting documentation for describing teh metadata and writing technical guides.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted teh results into reports and kept logs.
• Involved in Implementation of database design and administration of SQL based database.
• Optimized queries and stored procedures.
• Wrote T-SQL procedures to generate scripts dat modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform teh Data and worked extensively in T-SQL for various needs of teh transformations while loading teh data.
• Created Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements for various applications
• Responsible for transferring of teh databases and database objects from Development to Production Server using DTS.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures