SUMMARY

• Over 7 years of strong experience in Information technology industry covering all stages of development life cycle including business process analysis, requirements gathering and analysis, high level design, detailed design, development, testing, QA and post implementation support, SQL Server Architecture, Database Administration, Installation/ Configuration, Data Centre Management, Troubleshooting and Disaster Recovery.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2012/2008R2/2008/2005 in standalone and clustered environments.
• Experience in Java software development by using GUI development and connected with database.
• Experience in DataSync job on Windows Azure to synchronize data from MS SQL Server databases to SQL Azure.
• Experience in Data Extraction and Transforming and Loading (ETL) SQL Server Integration Services (SSIS) in MS SQL Server 2012/2008/2005, Import/Export data, Bulk insert and BCP.
• Experience in SSIS script transformations and scheduling complex SSIS packages for transferring data automatically from multiple data sources to SQL server.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Scheduling SSIS packages.
• Experience in migration of SQL Server from older version to newer version and documented the Upgrade process.
• Experience in developing reports in SQL Server 2012/2008R2/2008/2005 Reporting Services (SSRS) and deploying them using web applications onto web servers.
• Experience in configuring and deploying SSRS reports using MS - SharePoint Server.
• Experience in developing Drill Down, Cascading, Parameterized, Drill Through, Sub reports and Charts using Global variables, Expressions and Functions using SSRS for the Business Users.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging in SSRS.
• Involve in Analyzing, designing, building &, testing of OLAP cubes with SSAS and adding calculations using Multidimensional Expression queries (MDX).
• Experience in Microsoft T-SQL, creating and optimizing all database objects — complex Stored Procedures, Tables, Indexed Views, efficient Triggers, Indexes, User-defined Functions, and Sub Queries.
• Experience in Database Normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting.
• Highly skilled working as an individual as well in a team. Great ability to work on multiple projects at the same time, setting up priorities and delivering the requests before deadlines.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.

TECHNICAL SKILLS

• MS SQL Server 2012/2008/2005
• SQL Server Integration Services(SSIS)/SQL Server Analysis Services(SSAS)/SQL Server Reporting Services(SSRS)
• Windows Azure
• JAVA
• Windows NT
• Windows 8/7/XP/ 2003/2000/98
• UNIX
• LINUX
• Mac OSX
• HTML
• CSS
• JavaScript
• PHP
• Apache
• IIS
• .Net
• MS VISIO
• MS SQL
• Erwin 7.0
• SQL Profiler
• SQL Query Analyzer
• SQL
• T-SQL
• PL/SQL
• C
• C++
• C#
• VB
• MS ACCESS
• MS Office Suite
• Adobe Creative Suite
• Oracle 11g
• MySQL
• Google Analytics
• Crystal Report

PROFESSIONAL EXPERIENCE

Confidential, BOSTON, MA

MS SQL Server/BI Developer (SSIS/SSRS)

Responsibilities:

• Performed System Study, Requirements Analysis, Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, and Table Structures.
• Enhanced the logical and physical database design to fit business requirement, also implemented design into SQL Server 2012.
• Developed ETL process from Text Files, XML Files, SQL Server, Excel, OLEDB and Access to SQL Server Data Warehousing using SSIS packages.
• Developed SSIS packages using Lookup Transformations, Merge Joins, and Derived Columns with Multiple Data Flow tasks.
• Create XML package configurations, Error Handling using Event Handlers for on-error, on-warning, on-task failed event types using SSIS packages.
• Created script tasks of projects according to the requirements.
• Created Cascading Prompts, Sub-reports, Charts, Formulas, and also creation of navigation, dynamic, and parameterized reports using SSRS.
• Trained clients in SSRS to develop their own ad-hoc reports.
• Designed cubes with star schema using SSAS and wrote multi-dimensional queries and aggregate functions related to cubes, measures, hierarchies, processing cubes and deployment of cubes.
• Developed complex queries in T-SQL, Stored Procedures, and Views and optimized for best execution plan.
• Created trace using SQL Profiler and used Database engine tuning advisor for performance tuning on stored procedures and Scripts.
• Documented new procedures, troubleshoot issues, solutions, enhancements, daily-monthly changes of running processes, and maintain the database for future reference.

Environment: SQL Server 2012, SSIS, SSRS, C#,VB, SQL server profiler, Visual Studio 2010, Excel, Excel PowerPivot, MS Access, MS Visio, Google Analytics, Crystal Report, XML, MS Office 2010, Windows 7.

Confidential, El Monte, CA

MS SQL Server/BI Developer (SSIS/SSRS)

Responsibilities:

• Maintained and supported the enterprise data warehouse system and corresponding marts.
• Analyzed report requirements to fulfill customer needs and responses of server automated notifications.
• Supported enterprise conversion of Access and Crystal Report to a standardized SSRS format.
• Created dashboards for Sales, Marketing, Finance and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Created Drill down, Drill through, Sub-reports, Multi parameterized reports and linked reports using SSRS as well as manage the subscription of the reports.
• Developed reports using SSRS from a variety of data sources including Analysis Services Cubes and relational databases.
• Identified and troubleshot business process or data quality issues that show up in the reports and subsequently communicated to resolve and eliminate problems.
• Extracted data from Oracle, Flat Files, and loaded the Transformed data into the target Data warehouse using SSIS.
• Modified/created/maintained and optimize ETL processes using SSIS by using Data Conversion, Conditional Split, Merge Join.
• Created Data extraction and Import programs using SSIS using for-each Loop Container and C# scripting language.
• Handled Slowly Changing Dimensions to maintain historic data in OLAP using SSIS.
• Developed and maintained database stored procedures, views and functions.
• Followed the Agile Software Development Life Cycle methodology for adaptive planning, evolutionary development, prompt delivery, and continuous improvement for rapid and flexible response to requirement changes.

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, Oracle, SQL server profiler, Visual Studio 2010, Excel, Excel PowerPivot, MS Access, MS Visio, Crystal Report, XML, MS Office 2007, Windows 7.

Confidential, WOODBURY, NY

MS SQL Server/BI Developer (SSIS/SSRS)

Responsibilities:

• Performed analysis of complex data, suggest and implement appropriate resolutions to discrepancies, anomalies, and frameworks for ETL processes and Data Warehousing.
• Developed stored procedures to enhance performance of reports and ETL processes.
• Performed SSIS tasks using T- SQL, for-each loop and C# scripts scripting language to extract data from multiple excel sheets.
• Designed & Analyzed complex reports using SSRS by using Drill Down, Cascading, Parameterizing, Drill through, Sub reports to meet the changing requests of the business including on-going maintenance and enhancements.
• Designed, reviewed and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Extensively involved in creating Standard, Cross-tab, Drill Down, and Sub Reports (linked, unlinked and on-demand) using Crystal Reports 10.
• Maintained project documentation, testing, business logic, training and meetings.
• Participated proactively in the development and management of data analysis systems.
• Monitored relevant system usage and performance, with respect to the user presentation layer of the Data Warehouse.
• Involved in scheduling the monthly and Weekly Reports

Environment: SQL Server 2008, C#, SSIS, SSRS, Windows 2007, MS Visio, XML.

Confidential, SOMERSET, NJ

MS SQL Server/BI Developer (SSIS/SSRS)

Responsibilities:

• Reviewed architectures and designs of databases to ensure compliance with corporate objectives for data integrity, quality, performance, management, scalability, reliability, and security.
• Design and Implement Database Schema, Import data and build stored procedures on SQL Azure.
• Implemented database user access controls and data security measures.
• Managed databases and database servers in the absence of database administrator.
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed SSIS script tasks, look up transformations and data flow tasks using T- SQL, stored procedures and Visual Basic (VB) scripts.
• Designed, developed and deployed back-end systems to support operational and analytical reporting by using SSRS.
• Created, implemented and maintained standard reports while also customizing many reports to meet client needs.

Environment: SQL Server 2008, Windows Azure, SQL Azure, VB, SSIS, SSRS, Windows 2007, MS Visio, XML

Confidential, Manhattan, NY

MSSQL SERVER Developer/ Administrator

Responsibilities:

• Performed requirement analysis with the clients for deciding to improve website searching performance and maintained Database with Amazon Web Server configuration.
• Reviewed PHP code to diagnose the performance issue and Debugging the PHP code.
• Configured and add various log files in Apache via Linux, and reviewing general log file and slow log file to find query performance problem.
• Performed search engine optimization, reduced the website search time from 10 minutes to less than 10 seconds.
• Performed data migration using SSIS.
• Documented technical specifications and project reports.
• Administered database installations and upgrades, performance monitoring and tuning, backup and recovery, space management, capacity planning and resource utilization via the Linux command line.
• Analyzed database and implemented index, triggers, procedures, and materialize view to resolve the performance issue.

Environment: SQL Server 2005, SSIS, Windows XP, Linux Ubuntu, Apache, MYSQL, PHP, SQL Server, Amazon Web service.