SUMMARY

• Around 6 years of IT Professional experience in Development, Client Analysis, Database Design and Presentation using MS SQL Server 2000/2005/2008/2008 R2/2012.
• Excellent experience in MS SQL Server 2005/2008 with Business Intelligence in MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS).
• Excellent knowledge in Dimensional Modeling, ER Modeling, Data Marts, Star Schema / Snowflake Schema, FACT and Dimensional tables
• Experience across all phases of SDLC from project initiation to post - implementation.
• Experienced in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
• Experienced in creating Drill Through, Drill Down, Tabular, Matrix reports, Adhoc & created charts, graphs using Reporting Services (SSRS).
• Experience in deploying and enhancing the SSIS Packages from development server to production server and creating Databases on Functional Requirements and System Design.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Experience in RBMS Concepts, Database Management Systems, and Database Physical and Logical design & Data Modeling.
• Expertise in merging data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using import export wizard, DTS, SSIS, and bulk insert utilities.
• Design and create SQL database, tables, indexes, and views based on user requirements.
• Experience in using tools like Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning SQL Server Performance. Worked on Policy Management.
• Highly proficient in the use of SQL Server and T-SQL in creating indexes, Stored Procedures, Triggers, Tables, Views, user defined functions, User profiles, common table expressions (CTEs) to facilitate efficient data manipulation, data integrity and data consistency. and relational database models SQL joins and query writing.
• Involved in various admin level activities such as creating and maintaining of databases and other security objects like logins, Roles, Users and Schemas
• Experienced in Error and Event Handling: Check Points, Logging in SSIS.
• Expert in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous using DTS and SSIS of SQL Server 2000/2005/2008/2012 respectively.
• Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Experienced in sorting the data, defining data source and subtotals for the reports.
• Experience in working on administration tasks such as data loading, batch jobs, data unloading, user and application table management, upgrades, creating databases/ file groups/ files/ transaction logs.
• Involved in DBA activities such as Backups, Restores, Log-shipping, partitioning the tables, Mirroring and Replication and in resolving performance issues.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies.

TECHNICAL SKILLS

• SQL Server 2008/2005/2000
• SSRS 2008/2005
• SSAS 2008/2005
• SSIS 2008/2005
• DTS
• DB2
• MS-Access 2000
• MS Excel
• VB 6.0
• Developer 2000
• Oracle 11g
• T-SQL
• PL/SQL
• HTML
• XML
• XSL
• Java script
• VB Script
• Visual Studio 2008
• ODBC
• MS office
• Windows NT/ 2000 Server/ XP.

PROFESSIONAL EXPERIENCE

Confidential, New York City, New York

SQL Server BI Developer

Responsibilities:

• Involved in planning, design, analysis, implementation and maintenance of SQL server database.
• Involved in designing ER diagrams and mapped the data into database objects.
• Analyze technical and functional design documentations to develop SSIS packages and SQL Server Stored Procedures, to transform and load extract legacy data based on business rules and Field level mapping.
• Designed, developed and deployed reports, Drill down reports, Drill through reports and Parameterized reports in MS SQL Server environment using SSRS and also configured the Cache execution, report execution time out and scheduled Snapshot reports to increase performance.
• Scheduled the monthly/weekly/daily reports to run automatically
• Executed data conversion ETL packages and generated the appropriate execution reports.
• Developed stored procedures, views, and other objects required to transform, translate, retain Aggregate data for complex data conversion requirement
• Involved in transferring data from various data sources such as MS Excel, XML, Flat files, and CSV files into SQL server.
• Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.
• Created database, tables and procedures to update and clean the old data.
• Worked with the front end application developers with their queries.
• Designed many (SSIS) SQL server integration packages for migrating data using various Complex transformations such as derived column, lookup, and merge join.
• Scheduled the system and user database backups and restored them whenever necessary.
• Monitored SQL Server and tuned poor performing SQL scripts.
• In the SSIS packages used various control flow tasks such as for each loop, sequential container and bulk insert and execute SQL tasks.
• Extracted data from XML files and used various transformation techniques to cleanse the Data as per business requirement.
• Designed and maintained various types of reports using SSRS SQL server reporting services.
• Designed and implemented parameterized, drilldown and cascading reports using SSRS
• Involved in deploying reports to report manager and trouble shooting for any errors occurred in Deploying.
• Designed partitions in Cubes on time for improvement in performance using SSAS.
• Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements.

Environment: SQL Server, Windows Server, SQL Server Analysis Service (SSAS), SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS), T-SQL, XML, IIS, ERWIN.

Confidential, Jersey City, New Jersey

SQL Server BI Developer

Responsibilities:

• Involved in Designing ER diagrams and mapped the data into database objects.
• Involved in the analyzing and solved problems doing the Client Application system's installing, upgrading and running stages.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created schemas, views, stored procedures, Triggers and functions for Data Migration. Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer and SQL Enterprise Manager.
• Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Suggested creating Clustered and Non-Clustered indexes on tables.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.
• Designed and created ETL packages in MS SQL Server 2008 using SSIS.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Configured SQL mail Agent for sending Automatic emails on Errors
• Created the structure of the model and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements

Environment: Microsoft SQL Server 2005/2008, SQL Server Management Studio (SSMS), (BIDS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Oracle, Visual Studio 2008, T-SQL, XML, IIS, ERWIN.

Confidential, Bayonne, New Jersey

SQL Server BI Developer

Responsibilities:

• Built ETL design structure using SQL Server Integration Services by incorporating Extraction, Transformation, Load and Purge phases for the Enterprise Warehouse solution.
• Developed and implemented custom logging structure in Event Handlers for allthe SSIS packages using SSIS system variable such as Package Name, Package Start Time, etc.
• Designed and implemented data imports from several Point of System servers with SQL Server source as well as CSV flat file sources to Production environment using SQL Server Integration Services.
• Designed, developed and implemented various SSIS Packages and deployed using Deployment wizard.
• Effectively utilized protection level property of SSIS packages for secure storage and transfer.
• Implemented Encrypt AllWithPassword and ServerStorage protection level extensively during package development.
• Implemented parallel execution of SSIS Packages and actively utilized parent propagate property in event handlers for uninterrupted execution of SSIS packages.
• Extensively utilized expression and constraint feature for conditional processing of flat files and flow control in SSIS.
• Created different types of store procedure for the logging and auditing validation purposes.
• Created parameterized reports using SSRS
• Formatted the report layout for the requirement of the end users.
• Deployed the developed reports and upgraded the system.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Created complex Stored Procedures, Functions, Triggers, Tables, Indexes, Views, SQL joins and T-SQL, PL/SQL code and Ad-hoc SQL Queries to test and implement business rules.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.
• Create a complex store procedure to generate the different format files as per the Client required format.

Environment: SQL Server 2008 R2, SQL Developer, Oracle 11g, SQL Server Reporting services(SSRS), SQL Server Analysis Services(SSAS).

Confidential, Menlo Park, CA

SQL Server BI Developer/SSIS/SSRS

Responsibilities:

• Involved in upgrading the instance of development environment of SQL Server 2005 to SQL Server 2008 with appropriate hot fixes and service packs.
• Wrote several scripts such as finding long running queries, blocking sessions, archiving data from production server to archive server and populating reporting.
• Created Stored Procedures to perform calculation and update of data in the database.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Maintained SQL Scripts for creation of Database Objects.
• Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Worked on SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
• Compressed data files by removing empty database pages and updating index statistics.
• Configured snapshot replication for reporting, user acceptance test and development servers.
• Designed and implemented user log in and security.
• Maintained reliability and availability of existing MS SQL environments.
• Generated Daily, Weekly and Monthly scheduled based reports regarding assigned projects to designated Managers and Clients.
• Used SharePoint for deploying .rdl files and uploading of the internal business documents.
• Suggested Cost saving Techniques. Designing/ Implementing Backup policies for databases.

Environment: Microsoft SQL Server 2005/2008 Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Oracle 10g, T-SQL.