SAI

Direct: 630-***-****

acrh0z@r.postjobfree.com

OBJECTIVE

Seeking the position of a MS BI Developer to contribute my technical knowledge in both ETL\Relational and Reporting sides using SSIS, SSAS, SSRS and help in organizational growth and development.

Professional Achievements

Over 8+ years of Experience as MSBI and Database developer and Support of Microsoft SQL Server 2005/2008/2012 in Development, Test and Production Environments with various business domains like Financial, Manufacturing, Healthcare applications.

Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.

Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.

Extensively used SSIS packages to Import data from sources like Oracle, IBM DB2 AS400 (iSeries), Flat Files, Excel, HTML and Raw Files.

Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.

Experienced in Conversion of Complex DTS Packages to SSIS from scratch and also using third party tools like DTS Xchange.

Good Knowledge of Data Warehouse architecture and attribute relationships between Fact and Dim tables.

Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and Processing SSAS objects.

Experience in creating and scheduling SSIS Packages to perform Dimension and Cube Processing.

Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services and MDX technology of the analysis services.

Experience in gathering Business Requirements and translating them into technical specification and creating reports with respect to business requirement.

Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues.

Experience in Development, Implementation, ETL and Reporting in SQL Server 2005/2008/2012.

Experience in Visual Studio tools like TFS for Source Control

Efficient in creating Joins and Sub-Queries for complex queries involving multiple tables.

Experience in Normalization/Denormalization Techniques for optimum performance in relational and dimensional database environments.

Performed Duties like new account development, customer management, stakeholder identification, requirements analysis, product planning and scheduling, design, development and support, managing projects.

Good SQL server administration skills including database creation, backups, disaster recovery, database maintenance, user authorizations and resolving deadlocks.

Expertise with scheduling and monitoring jobs using SQL Server Agent to perform hourly/daily/monthly data loads.

Experienced in Agile Methodologies like attending daily Scrums, maintaining User Stories and Burndown Charts, Backlog Grooming and Retrospective.

Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and ability to think outside the box.

Skills

SQL Tools

SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Profiler, Sybase 12.5 ASE.

IBM Tools

IBM DB2.

Languages

C, C++, SQL, T-SQL, PL/SQL, Visual Basic 6.0, C#. NET, My SQL, VB.NET, HTML, CSS, AJAX, XML

Operating Systems

WINDOWS 95/2000/2003/XP/VISTA/7/8/8.1/UNIX,LINUX.

Databases

MS-SQL Server 2012/2008 R2/2008/2005/2000, MS-Access 2007/2010, Teradata and AS400.

ETL Tools

Data Transformation Services, SQL Server Integration Services (SSIS), dashboards tools, web tools.

Scripting

HTML, DHTML, XML, Shell Scripting, Power Shell 2.0.

Reporting Tools

SSRS, SSAS, Crystal Reports, Report Builder 3.0., Pyramid.

DB Utilities and design tools

SQL Server Management Utility, SQL Profiler, Query Analyzer, MDX scripting.

Application Software

Visual Studio 2008/2012/2012, SharePoint, SQL dialect, MS Office Tools, TFS.

Methodologies

Agile, Waterfall.

Professional Experience

Asurion Nashville TN

Feb ’12 - Current

ROLE: MS SQL Server / SSIS, SSRS/BI Developer SQL Server/ BI Developer.

RESPONSIBILITIES:

As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.

Actively involved in writing T-SQL Programming for implementing Stored Procedures and Functions and cursors, views for different tasks.

Experience in configuring package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.

Experience in writing C#/VB scripts to use in Script Task to perform various functions.

Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually.

Involved in creating SSIS packages with various transformations like Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.

Designed and implemented group by, drilldowns, drill through, Crystal Reports, sub-reports, Parameterized and cascading parameterized reports using SSRS.

Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.

Created Package Configurations to deploy the packages through DEV, TEST and PROD Environments.

Created Power Shell Scripts to deploy SSAS XMLA through different environments.

Used TFS to maintain code versions effectively.

ENVIRONMENT: MS SQL Server 2005/2008 R2/2012, MS SQL Integration Services 2008 R2/2012, MS Access,Crystal Reports, MS SQL Reporting Services 2008 R2/2012, SSAS Cubes, MS Excel Power Pivot, IBM DB2, SQL Server Agent, SharePoint, Visual Studio, TFS.

HCSC Chicago, IL

Jun ’10 – Dec ‘11

ROLE: MS SQL Server / SSIS, SSRS/BI Developer SQL Server.

RESPONSIBILITIES:

Collected business requirements from users and translated them as technical specifications and design documents for development.

Worked closely in developing the detail design document and presenting to the client and implementing their feedback on a weekly basis.

Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations like Conditional Split, Derived Column, Data Conversion, Look Up, and Merge Join as required using SSIS.

Deployed SSIS packages with a simple one-click deployment to the integration server.

Generated parameterized queries in SSRS 2008 R2 using data from SSAS Cubes and various heterogeneous data sources.

Experience in Report Builder in SSRS 2005 and 2008.

Created the SQL server users and file server users with required permissions by including them in the scripts. Created Cross-Tab reports, Summary reports by using SSRS and designed reports using Crystal Reports.

Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.

ENVIRONMENT: MS SQL Server 2008 R2/2012, Microstrategy, MS Access, MS SQL Integration Services 2008 R2/2012,Crystal Reports, MS SQL Reporting Services 2008 R2/2012, SSAS Cubes, MS Excel Power Pivot, IBM DB2, SQL Server Agent, SQL Server Reporting Services(SSRS).

CITI Bank Warren, NJ

Aug 09 – May 10

ROLE: SQL Server/ BI Developer.

RESPONSIBILITIES:

Created Complex Stored procedures, user defined Functions, Schema Binding Views.

Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.

Involved in Query optimization and tuning stored procedures for better performance.

Created packages in SSIS with error handling.

Identified and worked with parameters for parameterized reports in SSRS in SQL Server 2012.

Work closely with internal customers analyzing problems and to create and maintain reports, maintaining SSRS Reports and ad-hoc SQL scripts.

Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS 2012.

Efficiently helped in the Software Development Life Cycle (SDLC) processes specifically waterfall and Agile Scrum methodology including Analysis, Design, Programming, Testing and technical Documentation.

ENVIRONMENT: SQL Server 2012 Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), MDS, Netezza database, DQS, DTS, C#, .Net, T-SQL, XML, XD, MS Excel, MS Access, MS visual Studio, BIDS, MS Power Point 2012.

BCBS Jacksonville, FL

Mar 07 – Jul 09

ROLE: SQL Server/ BI Developer.

RESPONSIBILITIES:

Created SSIS packages to load data into Sql Server using various transformations in SSIS.

Created SSIS packages to load data into Sql Server using various transformations in SSIS.

Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.

Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports. Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2012 database and performed tuning and audit analysis on it.

Migrated database from SQL server 2008 R2 to SQL server 2012 using utilities i.e. exp/imp and attach/detach for SQL servers 2012 futures.

ENVIRONMENT: SQL Server 2008 R2/2012 (SSIS, SSAS, SSRS), MDX, T-SQL, Teradata, SQL Server Analysis Services, EDI, SQL Profiler, VSS, MS Excel 2010, MS Word 2010, Power point 2010, Netezza database, Crystal Reports.

Education

Bachelor of Technology in Computer Science from JNTU University, India.

Contact this candidate