sql developer (ssis,ssrs,ssas)
Resume:
Sundeep
Mobile: 302-***-****
Email: ***********@*****.***
TECHNICAL SUMMARY:
• Microsoft Certified Professional with 7 Years of extensive IT experience as a Microsoft
SQL Server 2000 /2005/2008/2008 R2 developer. Developer in creating Business
Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing
Relational Database model as per business needs in different domains like Insurance,
Banking, Telecomm, Finance and HealthCare.
• Participated in the Software Development Life Cycle (SDLC) processes including Analysis,
Design, Programming, Testing and Deployment.
• Worked on Designing, maintaining and publishing of the logical and physical data
models.
• Excellent backend skills in creating T-SQL objects like Tables, Stored Procedures,
Functions, User Defined Data-Types, Rules, And Defaults.
• Extensive experience in Extracting, Transforming and Loading (ETL) using SSIS, bulk
insert, BCP, DTS packages into the Data warehouse from heterogeneous.
• Experience in query optimization & performance tuning of stored procedures and
functions. Tuning tools were used to improve the performance of the database.
• Good understanding of .net application environment using windows servers, Apache and
IIS servers.
• Gained practical working knowledge of .NET Technologies & RDBMS with interface
designing & implementation.
• Experience working with different flowchart techniques for the data analysis and
processing.
• Created Cubes with Dimensions and Facts and calculating measures and dimension
members using Multidimensional expression (MDX).
• Good experience and understanding of database design, relational integrity constraints,
OLAP, OLTP and Normalizations.
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data
Mapping, Table Normalization, Optimization and Tuning.
• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge
of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data
Marts.
• Experience working with data cleaning and importing of data automations.
• Experienced in writing parameterized queries for generating Tabular reports,
Formatting report layout, Sub reports using Global Variables, Expressions, Functions,
Sorting the data, defining data source and sub totals for the reports using SSRS 2008/2005 /
Cognos.
• Experience in report writing using SQL Server Reporting Services (SSRS) / Cognos and
creating various types of reports like Table, Matrix, Drill Down, Drill Through,
Parameterized and Cascaded reports.
• Scheduling the daily, weekly and monthly reports and at the same time run them.
• Experience in using technologies for Dashboards, Excel Pivot and services.
• Experience in writing complex Stored Procedures, Indexed Views and Triggers for data
consistency and manipulation. These were implemented along with the designing of the
relational database models.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like
Execute SQL Task, bulk insert task, data flow task, file system task, Execute package
task, Send mail task, Transfer database task, for loop & foreach loop containers.
• Worked on SSIS transformations like Conditional Split, Lookup, Fuzzy grouping,
Merge, Union All, Data conversion, Multicast, Pivot & UnPivot.
• Upgrade enhancements, maintenance, production support and bug fixes for the project.
• Expert in creating and deploying SSRS Reports on the portal for user accessibility.
• Successfully implemented Log Shipping Technique to maintain a standby server backup for
Disaster Recovery.
• Experienced in client requirement Analysis, Logical and Physical design & development of
databases (using MS Visio, Erwin, normalization, and SQL Server Enterprise manager),
Resource Planning, Coding, Debugging, T esting, Deployment, Support and Maintenance of
business applications using SQL Server 2008/2005/2000, DTS, SSIS, SSAS and SSRS.
• Excellent communication and inter-personal skills with ability to develop creative solutions
for challenging client needs using agile methodologies.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team
member.
• Flexible and versatile to adapt to any new environment and work on any project.
• Flexile to provide with the on-call support even after the business hours.
EDUCATION
Bachelor of Technology, Jawaharlal Nehru Technological University, Hyderabad, India.
TECHNICAL SKILLS:
Operating Systems: Windows 2008 R2, Windows NT 2000/2003 Server, Windows XP/7, Linux.
Languages: C, T-SQL, ANSI SQL, Oracle PL/SQL, MYSQL, VB.Net, C#, ASP.NET, ADO.NET, JAVA.
RDBMS: Microsoft SQL Server 2008/2005 / 2000 / 7.0, MS Access 2003/2007/2010, Oracle 9i,
oracle 11g.
SQL Server Tools: SQL Server Management Studio, Configuration Manager, Enterprise Manager, Query
Analyzer, SQL Profiler, DTS, SSIS,SSRS, SSAS, Database Tuning Advisor, DTS, BCP, ODBC, SQL
OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio.
Web Servers: IIS 5.0/6.0, Apache.
Web Technologies: HTML, PHP, ASP.NET, XML, XHTML, IIS.
ETL Tool: DTS, SSIS.
Communication: HTTP, SOAP, FTP, SMTP, TCP/IP.
Version Control Tools: TFS, CVS, SVN, VFS.
Wireless tools: GSM, UMTS.
Development skills: Transact SQL (T-SQL), PL/SQL.
Modeling Tools: Erwin, MS-Visio. Redgate
Reporting Tools: SSRS, Crystal Reports, Cognos.
Scripting tools: SQL scripts, Linux scripts, Java script.
PROFESSONAL EXPERIENCE:
Blue Cross Blue Shield, Chicago, IL
February 2013 – Till Date
SQL Server / SSIS/ Cognos Developer
The Blue Cross and Blue Shield Association is a national federation of multiple independent, community-
based and locally operated Blue Cross ® and Blue Shield® companies. The Association grants licenses to
independent companies to use the trademarks and names in exclusive geographic areas.
Responsibilities:
• Worked on the prestigious Obama Health Care 2014 Migration Project.
• The goal of the project was to migrate all the members who currently have a health plan to the
new health coverage plans that were introduced by Obama to cover the latest policies.
• Participated in the Software Development Life Cycle ( SDLC) processes including Analysis,
Design, Programming, Testing and Deployment.
• Extensively used all features of MS SQL Server 2008 R2/2008/2005 as a SQL Developer.
• Created complex Stored Procedures, Functions, User Defined Data-Types, used complex
queries involving join and union of multiple tables.
• Wrote optimized T-SQL Stored Procedure to improve performance, preserve referential integrity
and provide application functionality.
• Upgrade enhancements, maintenance, production support and bug fixes for the project and the
data models.
• Created SSIS packages to load data into Database using Various SSIS Tasks like Execute
SQL Task, bulk insert task, data flow task, Send Email task, Conditional Split, Derived
Column.
• Performed Scheduling package execution in SSIS, Multi File Imports, Package configuration,
Debugging Tasks and Scripts in SSIS.
• Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• Used Sequence, for loop & foreach loop containers for repetitive control flow tasks.
• Was associated with the Business Analysts in aggregating the Business requirements, Planning
and the designing phases of the project.
• Worked closely with the .Net development team in accommodating all the requirements on the
Database design and stored procedures.
• Supported the QA team for Regression testing by providing them with all the data inputs and
implementation plans for all the business requirements.
• Worked on developing the Cognos Dashboard reports and the ADHOC reports also worked on
scheduling these reports to run daily and every week.
• Developed complex Drill-through and Drill-down Cognos reports.
• Developed complex stored procedures and complex queries for the Cognos Dashboard and
ADHOC Reports.
• Developed code which facilitates extraction of all the member’s communication details, which in-
turn was used to communicate with the customers.
Environment: SQL Server 2008 R2 Enterprise Edition, SSIS, T-SQL, Cognos, Windows Server
2008,Performance Point Server 2007, Excel, XML,.NET, Redgate
Kindred Healthcare, Louisville, KY
January 2012 – January 2013
SQL Server/SSIS/SSRS/SSAS Developer
Kindred Healthcare Incorporated is a healthcare services company that through its subsidiaries
operates hospitals, nursing centers, and contract rehabilitation services across the United States. Kindred
is the largest diversified post-acute healthcare provider in the U.S. Its headquarters and support center is
located in Louisville, Kentucky.
Responsibilities:
• Participated in the Software Development Life Cycle ( SDLC) processes including Analysis,
Design, Programming, Testing and Deployment.
• Extensively used all features of MS SQL Server 2008 R2/2008/2005 as a SQL Developer.
• Created Stored Procedures, Functions, User Defined Data-Types, used complex queries
involving join and union of multiple tables.
• Worked on designing and developing Data Warehouses, Data marts and Business
Intelligence.
• Upgrade enhancements, maintenance, production support and bug fixes for the project and the
data models.
• Actively participated in interaction with users, team lead and technical manager to fully
understand the requirements of the system.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like
Execute SQL Task, bulk insert task, data flow task, file system task.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data
Scrubbing, data validation checks during Staging, before loading the data into the Data
warehouse.
• Implemented Complex Logging in SSIS Packages.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count
Transformations.
• Designed and developed SSIS Packages to extract data from various data sources such as
Access database, Excel spreadsheet and flat files into SQL server 2008 for further Data Analysis
and Reporting by using multiple transformations provided by SSIS such as Data Conversion,
Conditional Split, Bulk Insert, merge and union all.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and
subscriptions for the reports. (SSRS)(2005/2008).
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports
by using crystal reports/ SSRS.
• Wrote parameterized queries for generating Tabular reports, Formatting report layout, Sub
reports using Global Variables.
• Implemented Type 2 Slowly Changing Dimension to maintain Dimension History.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and
oracle).
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in
SSIS.
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Scheduling package execution in SSIS.
• Installing packages on multiple servers in SSIS.
• Used SSRS to Reporting for a Data warehouse system.
• Worked on the query optimization & performance tuning of complex stored procedures and
functions.
Environment: SQL Server 2008 R2/2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows
Server 2008/2003, Oracle 9i,Performance Point Server 2007, Excel, XML,.NET
Bank Of America, Agoura Hills, CA
February 2010 – January 2012
SQL Server (SSIS/SSRS/SSAS) Developer/DBA
Bank of America Corporation is an American multinational banking and financial services corporation
headquartered in Charlotte, North Carolina. It is the second largest bank holding company in the United
States by assets. Bank of America is the world's largest wealth management corporation and a major
player in the investment banking market.
Responsibilities:
• Efficiently helped in the Software Development Life Cycle ( SDLC) processes including
Analysis, Design, Programming, Testing and Deployment.
• Installation and configuration of SQL Server 2008 R2/2005.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Functions,
User Defined Data-Types, Rules, And Defaults.
• Created Cubes with Dimensions and Facts and calculating measures and dimension members
using Multidimensional expression (MDX).
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries
with MDX, Data Mining Models, developing reports using MDX and SQL.
• Upgrade enhancements, maintenance, production support and bug fixes for the project and the
data models.
• Automate and enhance daily administrative tasks, including space management, object alteration,
backup & recovery and performance monitoring.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for
proactively monitoring the performance of SQL Server databases.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports
using SQL Server Reporting Services 2008 R2.
• Involved in Migration of SSRS 2005 to SSRS 2008 R2.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP,
Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis
Services.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL
Server 2005/2008.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like
Execute SQL Task, bulk insert task, Execute package task, Send mail task, Transfer
database task, for loop & foreach loop containers.
• Worked on SSIS transformations like Conditional Split, Lookup, Fuzzy grouping, Merge,
Union All, Data conversion, Multicast, Pivot & UnPivot.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with
the help of SSIS.
• Deploy SSIS Package into Production and used Package configuration to export various package
properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to
various user communities.
Environment: SQL Server 2005/2008 R2 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows
Server 2003, Oracle 9i,Performance Point Server 2007.
Arch Insurance, Jersey City, NJ
May 2008 –January 2010
SQL Server(SSAS/SSIS/SSRS) Developer
Arch Insurance Group (Arch), a division of Arch Capital Group Ltd., is a market-leading specialty
insurer. It provides a wide range of property, casualty and specialty insurance for corporations,
professional firms and financial institutions across the United States and Canada.
Responsibilities:
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Functions,
Triggers, User-Defined Data-Types.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing
Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Installation and configuration of SQL Server Reporting Services (SSRS) 2008.
• Created Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports,
Adhoc reports through Report Builder.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and
subscriptions for the reports. (SSRS)(2005/2008).
• Involved in creating report models and applying row level security filters for report model.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).
• Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration
Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with
error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using
SSIS.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute
SQL Task, bulk insert task, Execute package task, Transfer database task, for loop & foreach loop
containers.
• Hands on experience in using different transformations like fuzzy lookup, derived column,
Conditional Split, Lookup, Merge, Union All, Data conversion, Pivot & UnPivot.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Designed high level ETL architecture for overall data transfer from the source server to the
Enterprise Services Warehouse which encompasses server name, database name, accounts, tables
and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Played a major role in the production support of SSAS cubes and SSIS jobs.
• Developing the User-Interface Front-end screens in .Net 3.5 environment using
C#.Net, Asp.Net, JavaScript, HTML and DHTML
Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS,
SSRS), ProClarity Server, XML, MS PowerPoint, MS Access 2003 & UNIX, Shell Scripting,
Oracle.
State Bank Of India, India
September 2006 – may 2008
SQL Developer/DBA
State Bank of India (SBI) is a banking and financial services company based in India. It is a state-
owned corporation with its headquarters in Mumbai, Maharashtra. The bank traces its ancestry to British
India, through the Imperial Bank of India, to the founding in 1806 of the Bank of Calcutta, making it the
oldest commercial bank in the Indian Subcontinent.
Responsibilities:
• Developed the Functional specification documentation for the modules to be developed.
• Worked with SQL and PL/SQL to create Tables, Views, and triggers and stored Procedures.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and
implemented referential integrity constraints for enforcing data integrity and business rules
• Responsible for tuning T-SQL procedures, triggers and other database objects.
• Fine tuned and checked the performance of existing objects in SQL Server and implemented
transactional logic for them
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and also created linked server with
different access files used across various departments
• Created complex reports in Crystal Reports using procedures from SQL Server by passing in
stored procedure parameters
• Responsible for SQL Server 2000 database development, database modeling, database program,
database administrator
• Performed DBA tasks through Enterprise Manager, Query Analyzer, English Query, Import
Export wizard
• Maintain and implement the database using SQL Server 2000 back-end tools and DTS.
• Design, develop and administer the E-Work platform website
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development,
Implementation.
• Upgrade enhancements, maintenance, production support and bug fixing for the product.
Environment: T-SQL, SQL Server 2000, OLAP Services, Windows 2000 Server, Query Analyzer,
DTS,MS Access 2000, Oracle, VB.net 2003, Erwin Data Modeler .
Contact this candidate