SUMMARY

• Over 8 years of experience in IT as a SQL Developer with specialized skills in SSIS, SSAS, and SSRS.
• Experience in managing security of SQL Server 2014/2012/2008 R 2/ 2008/2005/2000 databases by creating database users and roles, and assigning proper permissions according to business requirements.
• Strong SQL Server 2008/2005/2000 development skills including writing stored procedures, user - defined functions, triggers, views, and indexes.
• Strong Transact-SQL query writing skills (DDL, DML, and DCL).
• Excellent command of writing ad hoc queries utilizing dynamic SQL.
• Expert in SQL Server Business Intelligence suite of products like SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
• Expertise in creating reports of all types in SSRS, like ad hoc, drill-down, pivot, and tabular reports.
• Experience in creating DTS/SSIS packages with ActiveX scripting for transferred data modifications.
• Experience using SSIS tools like Import/Export Wizard, Package Installation, and SSIS Package Designer.
• Strong experience in defining referenced relationships and identifying KPIs in SSAS 2008/2005.
• Experience in Error handling and debugging coding issues and troubleshoot production problems.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.

TECHNICAL SKILLS

Operating systems: Windows 98/NT/2000/XP/Vista/7

Databases: SQL Server 2000/ 2005/2008/2008 R2/2012/2014, Access

Database tools: SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, Microsoft OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), EDI

ETL tools: DTS, SQL Server Integration Services, SQL Server Analysis Services, EDI Kit

Reporting tools: SQL Server Reporting Services (SSRS), Crystal Reports

Development skills: Transact SQL (T-SQL), PL/SQL

Languages: C, C++, HTML, XML, VB.NET, ASP.NET (C#)

Application packages: Microsoft Office Suite

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. SQL Server/MSBI Developer

Responsibilities:

• Created and managed stored procedures, indexed views, user defined functions, triggers, database constraints to meet business requirements and policies.
• Project involved maintenance of existing OLTP databases as well as designing SSIS packages for custom warehousing needs.
• Involved in the data analysis and database modeling of both OLTP and OLAP environment.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Collaborated in dramatically increasing OLTP transactions on systems handling several billion transactions weekly through the implementation of advanced database techniques such as join optimization, table structure and fragmentation analysis, bulk inserts, analysis of indexes and locks, creation of custom timers to detect bottlenecks.
• Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2005 and unit test SSIS load processes for performance check.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005) according to ERLC.
• Involved in migration and Conversion of Reports from SSRS .
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Environment: SQL Server 2005/2008/2012 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS),OLTP, OLAP, Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Crystal Reports, Cogon's, Business Objects, SharePoint, MOSS 2007

Confidential, Parsippany, NJ

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Responsible for creation and maintenance of tables, indexes, stored procedures, triggers, and UDF’s
• Debugging of stored procedures, Indexes, Triggers, Views, User Defined Functions and Cursors
• Tuned Poor performing SQL Queries with SQL Profiler Trace and Query Analyzer
• Enforced business rules with checks and constraints
• Involved in code review and code review meetings
• Conversion / Migration of SQL Server 2005 to SQL Server 2008
• Used various script tasks, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task etc. and different data flow tasks using T- SQL and Visual Basic (VB) scripts
• Created and scheduled SSIS packages to pull data from SQL Server database and export the data to various data sources like excel spreadsheets, flat file etc. and vice versa
• Created SSIS Packages using the concepts of incremental loading and slowly changing dimensions
• Worked on performance tuning of SSIS packages using error handling, event handling, re-running of failed SSIS packages using checkpoints
• Involved in migration and conversion of Reports from SSRS
• Created Parameterized, Cross-Tab, Drill Down & Drill Through reports by using SSRS 2005/2008
• Created report models for the ad-hoc reporting of the end users using Report Builder
• Deployed SSRS reports in share point for web based access for multiple end users
• Created cubes, dimensions, measures and calculated measures according to the requirements
• Deployed and processed Cubes on a weekly basis to update information using SQL Server Agent
• Built MDX Queries using SQL Server Analysis Server (SSAS) 2008/2005
• Documented all the migration process documents for future reference
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and index configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation

Confidential, Fort Worth, TX

SQL/ETL/SSIS Integration Analyst

Responsibilities:

• Created and managed stored procedures, indexed views, user-defined functions, triggers, and database constraints to meet business requirements and policies.
• Created complex queries for database auditing purposes.
• Used DTS/SSIS for ETL processes, SSRS for reporting needs, and SSAS for analytics reporting including SharePoint integration.
• Created highly complex SSIS packages using various data transformations like conditional splitting, fuzzy lookup, multi-cast, column conversion, fuzzy grouping, script components, and error handling.
• Generated custom ETL scripts using SSIS 2005 and unit tested load processes for performance check.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Gained understanding of OLAP processing for changing and maintaining warehousing optimizing dimensions and hierarchies and adding aggregations to cube.
• Involved in writing MDX queries and performance optimization of SSAS cubes for calculated members and measure groups.
• Created various complex reports and managed them using SSRS 2008/2005 according to ERLC.
• Involved in migration and conversion of reports from SSRS .
• Created tabular reports, matrix reports, list and chart reports, parameterized reports, sub reports, ad hoc reports, drill-down reports and interactive reports according to business requirements in time-restricted environment.
• Created SSRS report model projects in BI studio and created, modified, and managed various report models with multiple model objects, source fields, and expressions.
• Highly involved in creating, structuring, and formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate special reports according to client needs.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007 and SharePoint.
• Deployed designed PPS dashboards and reports in MOSS site using PPS Dashboard Viewer Web Part for web-based access for multiple end users.

Environment: SQL Server 2005/2008/2008 R2 Enterprise Edition, .NET 3.5, SQL BI Suite 2008 (SSAS, SSIS, SSRS), Enterprise Manager, PPS, XML, PowerPoint, Project, Access 2003,Windows Server 2003, Oracle, Crystal Reports, Cognos, Business Objects, SharePoint, MOSS 2007.

Confidential, Lake Forest, CA

Senior SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Scheduled cube processing from staging database tables using SQL Server Agent.
• Wrote MDX queries and expressions for use in front-end BI applications and created KPI objects in line with requirements.
• Optimized cubes for better query performance and processed cubes to perform incremental updates.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports with drill-down, drill-through, and drop-down menu options as well as parameterized and linked reports.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly, and quarterly reports including current status.
• Created report models, standard report subscriptions, and data-driven report subscriptions.
• Created report snapshots and cache for better performance.
• Created user-defined functions in SSRS using VBScript.
• Generated test data and tested database to meet functionality deliverables in project documentation and specifications.
• Provided knowledge transfer to company’s SQL developers.
• Created several materialized views and UDFs to be accessed by new front-end applications.
• Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance database performance.
• Optimized performance of various SQL scripts, stored procedures, and triggers by using embedded UDFs, CTEs, and system stored procedures.
• Successfully tested all tasks in staging, and stored all versions of data using Team Foundation Server.

Environment: SQL Server 2008R2/2008/2005, Business Intelligence Development Studio (BIDS) 2008, SQL Server Reporting Services (SSRS) 2008, SQL Server Integration Services (SSIS) 2008, SQL Server Analysis Services (SSAS) 2008, Windows Server 2003, HealthCare database, Oracle 9i, DB2, SharePoint Server, Team Foundation Server.

Confidential

Programmer/SQL Server Analyst

Responsibilities:

• Studied and understood requirements of information required by company’s procurement department about vendors.
• Normalized data sets and re-designed data from scratch, including logical and physical design.
• Actively involved in troubleshooting problems throughout development process.
• Installed, updated, configured, and maintained SQL Server.
• Created report interface using VB6, which allowed users to select and dynamically filter reports.
• Tuned front-end applications like Visual Basic, which queried SQL Server database.
• Involved in implementation of user logins, roles, and profiles as part of security policies for various categories of users.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user-defined functions.
• Wrote T-SQL queries for data retrieval.
• Developed administrative tasks of SQL Server for performing daily backups and recovery procedures.
• Worked with development team in writing functions in VB6 for upload/download functionality, data transfer, and migration.
• Involved in developing functions in VB for encryption and decryption of passwords and user names.
• Developed code and analyzed it in VB6 for front-end interface.
• Played important role in ensuring timely delivery of whole set of data and queries to procurement department.

Environment: SQL Server 2008R2/2008/2005, Windows NT, Visual Basic 6.0, Access, Excel, Windows 2000.