SUMMARY

• Experienced professional with comprehensive skills as a BI consultant.
• Comprehensive understanding of the business data model with strong process - to-technology mapping capabilities and full grasp of integration issues.
• Around 9 years of IT experience in software development, designing and implementation with major focus around Business Intelligence, Data Warehousing and Database Applications.
• Over 6 years of experience with Business Intelligence tools in Microsoft Suite such as SSIS/SSRS/MS OLAP/DTS services using databases SQL SERVER 2005/2000, Oracle.
• Upgraded SQL Server 2000 DTS Packages to SSIS for uploading various formats of files and databases to MS SQL Server 2005 using SQL Server Integration Services (SSIS).
• Migrated data from various data sources using SSIS Transformations like Aggregate, Lookup, Conditional-split, Merge Join, WebService task and Sort.
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Designed/Implemented Dashboards, Scorecard reports for SQL Reporting Services group using Visual Studio.Net.
• Responsible for the design and development of reports and SQL queries dat pulls data from multiple SQL Server databases.
• Designed Best practices document for SSRS reporting.
• Developed Business Intelligence solutions such as Executive Dashboards and Business Scorecards using SSRS.
• Experience in scheduling Snapshot/Subscription SSRS reports via .rss and .bat files
• Experience in creating EXE and DLL files using Visual Studio 2005/2008
• Experience in developing Business rules Engine (BRE) Using SSIS
• Proficient in creating ETL packages using SQL Server R2 / 2012 Integration Services (SSIS).
• Upgraded SQL Server 2000 DTS Packages to SSIS for uploading various formats of files and databases to MS SQL Server 2005 using SQL Server Integration Services (SSIS).
• Experience in creating DTS/SSIS packages with ActiveX scripting for transferred data modifications.
• Experience in using Transformations like Aggregate, Lookup, Merge Join, Sort etc.
• Knowledge in building Multidimensional Expression (MDX) queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Good Knowledge in Java, MS-SQL Server 2000/20, and Oracle-8i and MS-Access databases.
• Transformed data from one server to other server using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS).
• Created logical and physical data modeling and E-R diagrams using Erwin tool.

TECHNICAL SKILLS

Operating Systems: Windows-2000/2003/XP

Languages: Java, C++, C, VB.Net, C#, XML

Web Technologies: Java Script, HTML, ASP

Databases: SQL Server 2000/2005/2008 , ORACLE 8i, MS-Access, IBM DB2

SQL Server Tools: Enterprise Manager, Query Analyzer, Export & Import, DTS, Replication, Management Studio, BI Development Studio, SSIS, SSRS, SQL Profiler, SSAS, MOM 2005,Visual Studio R2 / 2012

Web Servers: Apache Tomcat 5.0, Web Logic 8.0, IIS 6.0

Miscellaneous Tools: IP Monitoring, Cacti, EAS, WS-SFTP, DbVisualizer, Autosys, UniCenter

Design Tools: Erwin 4.0

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

Sr.SQL / BI Consultant

Responsibilities:

• Installed and configured SQL Server 2008 R2, SQL Server 2012, Visual Studio 2008/2010 and TFS in Dev environment.
• Converted existing SQL Server 2000 DTS packages to SSIS using SSIS 2008 R2 to run the process much faster.
• Gatheird requirements from Tech Lead and GuideWire Architects.
• Worked on conversion of Guide Wire 3.0 reports to SSRS reports using SSRS 2008 R2
• Extensively used SSIS (ETL) to extract and transform Policy Insurance data from ODS, Flat files, XML Data, SQL Server 2008 instances and load into Billing Center staging tables and tan to Billing Center Database for further Analysis and Reports.
• Design and developed cascading parameterized reports, Drill down, Drill through, tabular reports using SSRS 2008 R2 and deployed those to PNI-SharePoint reporting site.
• Created daily and monthly Snapshot reports using Global Variables, Expressions, Functions and .rss files using SSRS and send snapshot/subscription reports to different end users via automated batch process.
• Design and developed database objects for implementing the new billing payment process into the existing system.
• Using SSIS 2012 created a balancing email process to track the counts for the number of source records processed and the number of inserts/updates processed in the destination tables.
• Used Event Handlers (On Error, On Task Failed) for enterprise custom data logging using SSIS WebService task.
• Created SSIS XML-Configuration files to run the packages on different environments (Dev, QA, Model, Prod) without any manual changes needed to the package.
• Created tables, Indexes and stored procedures on SQL Server2008 database.
• Extensively used Joins, Common Table Expressions (CTE), SQL Merge Commands and stored procedures.
• Responsible for designing, developing, testing and troubleshooting SSIS packages dat implement complex Extraction, Transforming and Loading (ETL) processes.
• Used WebService task in SSIS for enterprise data logging.
• Responsible for fixing data issues/defects in SSIS packages and SSRS reports dat occur in different environments.
• Used Vb.net code in SSIS 2012 script task and script components for reading fixed width PNI-Billing Cash Management System (BCMS) files.
• Performed SSIS and SSRS code migrations to different environments on request.
• Design and developed SSIS packages to pull data from Agency, PNI-Policy Administration System (PAS) and load into Billing Center database for reporting and further analysis.

Environment: MS SQL Server 2008 R2, MS SQL Server 2012, Integration Services (SSIS 2008 R2 / 2012), Reporting Services (SSRS 2008 R2), VB.Net, Visual Studio, Team Foundation Server (TFS), GuideWire 7.0, UniCenter, SharePoint

Confidential, Owings Mills, MD

SSIS Consultant

Responsibilities:

• Upgrade SSIS 2005 packages to SSIS 2008
• Loading data from different sources like CSV, Excel, SQL Server 2008 and IBM DB2 into CRM Pivotal-Touch point using SSIS 2008
• Used CRM Pivotal-Touchpoint plug-in components like pivotal destination and pivotal command task in SSIS 2008 for loading data from various sources into Touchpoint
• Used DB2 as source in SSIS 2008 to load Master and Incremental data from DB2- Email Address Management(EAM) into CRM Touchpoint
• Used VB.Net code in SSIS script task for sending dynamic email attachments with customized logging information
• Used VB.Net code in SSIS 2008 script task for loading T Rowe Price documents( pdf, word, JPEG images, excel) from a network secured shared directory into SQL server table
• Responsible for fixing data issues occurred in Production
• Create views in MS-SharePoint 2007
• Using autosys job scheduling tool, scheduled various SSIS jobs in Dev\Qual\Prod environments
• Created SSIS packages to backup and restore CRM-Touch point user groups and licenses
• Worked on performing backups and restore of CRM Touch point enterprise-data and business module databases
• Responsible for installing and configuring satellite server setup in testing environment after restoring of CRM-Touch point enterprise-data and business module databases
• Assigning Touchpoint security groups and licenses to users in development and testing environments using CRM-Touchpoint Pivotal Administration Console (PAC)
• Responsible for gathering SSIS requirements from business analysts and architects
• Responsible for installing and configuring Touchpoint pivotal business server (PBS-V.6),pivotal client packaged components and pivotal hot fixes in development and testing environments
• Used Team foundation server(TFS) to keep track of SSIS packages version control

Environment: MS SQL Server 2005, MS SQL Server 2008, Windows 2003 Server, Integration Services (SSIS 2005), VB.Net, Visual Studio 2008, Oracle, DB2, DbVisualizer, Team Foundation Server, CRM-Touch point pivotal v.6, Autosys tool, SharePoint 2007

Confidential, Columbia, MD

SSIS\SSRS Consultant

Responsibilities:

• Using SSIS developed Interfaces for extracting and loading data from various sources like Intersystem cache database, SQL Server 2005 and CSV files
• Created tables, Indexes, triggers and stored procedures on SQL Server2005 database using T-SQL
• Developed a generic table driven Business Rules Engine(BRE) for extracting and transforming data based on rules/condition using SSIS and VB.Net
• Using SSIS Implemented Incremental upload method on the tables for loading data based on new/existing records
• Developed web service oriented .DLL files for pulling data from Salesforce.com to load data into data warehouse and created public strong name keys to add DLL files to Windows assembly(GAC) using SSIS and C# (Visual Studio 2008)
• Developed SSIS Interface to read and load the Health Level (HL7) file into data warehouse
• Used various SSIS tasks & transformations like Pivot, Unpivot, conditional split, XML task, Script task, FTP and Send mail task
• Used WS-SFTP software to upload and download EDI 271 files from Emdeon Secure FTP site using SSIS and VB.Net
• Using SSIS Interface processed the health care EDI 271 response file
• Developed reports using SSRS 2005 to generate all daily, weekly, monthly reports
• Developed Billing, Online data entry(ODE) complex reports for Confidential using SSRS 2005 like drill up/drill down, parameterized and multi valued reports
• Created XML package configuration files for deploying SSIS packages to SQL Server 2005 and Scheduled packages on production servers using SQL Server Agent
• Designed Solid detail design documentation for various SSIS conversion process configured Logging, Auditing, Sending mail alerts and check point files on production servers using SSIS
• Used Team foundation server(TFS) to keep track of SSIS packages and SSRS reports

Environment: MS SQL Server 2005, MS Share Point, Windows 2003 Server, Reporting services (SSRS 2005), Integration Services (SSIS 2005), VB.Net, C#, Visual Studio 2005/2008, Inter System cache database, Team Foundation Server

Confidential, Franklin, TN

SSIS/SSRS Consultant

Responsibilities:

• Worked with XML configuration files for deploying SSIS packages from development to production environment.
• Worked on support of transactions for a data load using SSIS.
• Created objects like tables, views, stored procedures and handled performance tuning using T-SQL.
• Good experience in working with control flow and work flow tasks like Containers, Precedence Constraints, FTP, File System, Execute SQL task and writing VB.Net scripting in SSIS.
• Transformed the data using different transformations like Aggregate, split, join, merge, fuzzy lookup of SQL Server Integration Services (SSIS).
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and ETL package design, and RDBM systems like SQL Servers, Oracle.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Worked on property expressions, variables and configurations between SSIS packages.
• Generated TEMPeffective reports using formulae, sections, breaks, alerts, and filters.
• Used Best Practice approach for SQL code reviews and did documentation for the required changes
• Experience in working with Advanced reporting services programming using SSRS.
• Installed and scheduled tasks, configured email alerts to proprietary tool like MoveIT used to pick the payors files including PGP encrypted files from their SFTP to Confidential FTP site.
• Used EAS a proprietary tool for mapping, parse and validating the payors flat files in a structured format and inturn loaded into data warehouse.

Environment: MS SQL Server 2000, MS SQL Server 2005, MS Share Point, Windows 2003 Server, Reporting services (SSRS), DTS, Integration Services (SSIS), ipMonitoring, Cacti, EAS, MoveIt, VB.Net

Confidential, Silver Spring, MD

SSIS/SSRS/SSAS Consultant

Responsibilities:

• Upgraded SQL Server 2000 DTS Packages to SSIS for uploading various formats of files and databases to MS SQL Server 2005 using SQL Server Integration Services (SSIS).
• Migrated data from various data sources using SSIS Transformations like Aggregate, Lookup, Conditional-split, Merge Join and Sort.
• Created OLAP cubes using SQL Server 2005 Analysis Services (SSAS).
• Built MDX queries and DMX queries for Analysis Services & Reporting Services.
• Installed and administered MS SQL Server Reporting Services, created schedule reports and send the reports via email.
• Generated reports using SQL reporting services also used MDX queries to generate reports from cubes.
• Developed Drill through and Drill down reports using SQL Server Reporting Services (SSRS).
• Improved the responsiveness of reports and reduce the load on reporting services server using report cache and snapshot.
• Created DTS packages using Active X Task to migrate data from various sources like MS Access, Excel etc.
• Used SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Installed SQL Server 2000 on the server and client machines, providing connections and managing databases.
• Created logical and physical data models according to the business requirements.
• Created procedures, functions, and triggers, handling database performance and tuning.
• Monitoring and trouble shooting by using windows system monitor to create alerts, notifications and emails for system errors, insufficient resources, fatal database errors, and hardware errors.

Environment: MS SQL Server 2000, MS SQL Server 2005, Windows 2000 Advanced Server with SP4Erwin 4.0, XML, Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS)

Confidential, San Antonio, TX

MS SQL Server Developer

Responsibilities:

• Parallel Testing of Upgrading SQL Server 2000 to SQL Server 2005 and implemented it successfully in Testing Environment.
• Upgraded SQL Server 2000 DTS Packages to SSIS for uploading various formats of files and databases to MS SQL Server 2005 using SQL Server Integration Services (SSIS).
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors.
• Administrator tasks such as managing users, roles, and profiles.
• Used DTS Packages for data Import/Export data from SQL Server to Access, Text and Excel files.
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
• Experience in developing and formatting interactive sort reports using SQL Server Reporting Services (SSRS).
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Checked Performance Tuning, Indexing, Query Optimization.
• Configured database mail, created operators, jobs, alerts for automating databases.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Environment: Windows Server 2000, Windows 2003 Server Enterprise Edition, MS SQL Server 2000MS SQL Server2005, IIS 6.0, XML, Erwin 4.0, SSRS, SSIS, DTS, MS Share Point.

Confidential, Cumberland, MD

MS SQL Server Database Administrator

Responsibilities:

• Involved in Creating tables, indexes and designing constraints.
• Performance Monitoring with SQL Profiler and Windows System Monitor.
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Created and Maintained Database Maintenance Plans.
• Defined schemas and created SSIS packages in SQL Server 2005 for the migration process.
• Transformed the data using different transformations of SQL Server Integration Services (SSIS).
• Generated the reports for doctors and other officials using SQL Server 2005 Reporting Services.
• Reduced the Query Execution time by Monitoring and Tuning Indexes using Index Tuning Wizard.
• Upgraded from SQL Server 2000 server to SQL Server 2005.
• Designed DTS package, with DTS Import/Export wizard for transferring data.
• Coordinated with the programmer analyst for optimizing query, writing stored procedures.
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors.

Environment: SQL Server 2000 with SP4,MS SQL Server 2005, Windows 2003 Server, Windows 2000 Advanced Server, IIS 6.0, Reporting Services, DTS, MS Visual Studio.Net

Confidential, NYC, NY

MS SQL Server DBA/Developer

Responsibilities:

• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Designed a report for the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Scheduled backups and performed restore operations for system test data depends on testers’ requirement.
• Performed DBCC checks and fixing data corruption in Application databases.
• Created Databases, tables and provide constraints and user defined rules and defaults.
• Created tables, views, indexes, stored procedures, triggers and constraints.
• Performance Tuning and optimizing for SQL Server Applications by using performance monitor assist the SQL developers in SQL tuning.
• Setup backup and recovery scripts.
• Administered the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
• Configured database mail, created operators, jobs, alerts for automating databases.
• Run DBCC consistency checks, rebuild indexes, and update statistics for databases on regular basis.
• Data transfers between various servers using BCP and DTS.

Environment: MS SQL Server 7.0, MS SQL Server 2000, T-SQL, Windows 2000/2003 Server, VB 6.0

Confidential

MS SQL Server Developer

Responsibilities:

• Involved in Security Administration- creating users and assigning them roles and privileges.
• Website creation and Administration of URL ( http://aptransport.ap.gov.in/navigation/).
• Configuration of client side Patch Software with database server for total Andhra Pradesh (AP) clients.
• Maintained the database server and monitoring the data (XML file), uploaded by the operator.
• Created a backup for databases and XML files.
• Configuring of client side Patch Software with database server.
• Produced ASP application reports for analysis.
• Troubleshooting client side problems.
• Design and coding of server Database.
• Design and coding in MS-Access for patch software (This Software is used to generate XML Files and tan zip dat XML files into single file from client database daily wise which will tan Unzipped at server side before storing into the database. This software is universal for all the Petrol & Diesel software’s of Andhra Pradesh).
• Installation of SQL Server2000 Service Packs.
• Worked extensively on Data Transformation Services (DTS) for transferring data between discrete data sources.
• Worked with developers to tune queries, stored procedures, run scripts and move databases.
• Involved in daily database administration activities and troubleshooting database problems.

Environment: SQL Server 2000 with SP3, Windows 2000 Server, XML, Visual Basic 6.0MS-Access, IIS 6.0