PROFESSIONAL SUMMARY:

• 6+ years of professional experience in IT in the areas of analysis, SAP Business Object 4.1, Personify 360, design development of Data warehousing and business intelligence solutions using ETL/OLAP with Microsoft SQL Server Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
• Experience in the field of SAP Business Object 4.1, Universe Designer, Web reporting, Dashboards Design.
• Extensive exposure in creating Database Objects from scratch, writing T - SQL code, Stored Procedures, Triggers, Views, User Defined Functions and Cursors.
• Experience in Constraints, rules, and default setting Primary, Foreign, Unique and Default Key.
• Develop Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Experience in developing Enterprise level Data warehouse (EDW), Data marts and Operational database (ODS).
• Experience in creating a complex mapping using various transformations and developing strategies for Extraction, Transformation and Loading (ETL) mechanism mainly using MS SQL SSIS.
• Experience in writing complex subqueries, PL/SQL programs (functions, procedures, and packages), and stored procedures.
• Involved in complete Software development life cycle (SDLC)of the project, experience in business requirements gathering, define and capture metadata for business rules, system analysis design development production support testing user training and strategic decision-making problems solving associated with the ETL processes by working closely with the different team.
• Worked with heterogeneous data sources like Oracle, SQL Server, flat files, and XML files.
• Used Metadata Manager (MDM) to extract metadata from the application, business intelligence, data integration data modeling and relational metadata sources.
• Expert in troubleshooting/debugging and improving performance at different states like database workflow mapping.
• Experience in Performance tuning of the source, transformations targets mapping workflows sessions and batches.
• Experience in developing Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drill down, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Enthusiastic and goal-oriented team player possessing excellent communication interpersonal skills and leadership capabilities with a high level of adaptability skill.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio (SSMS)

Data Warehouse Tools: MS SQL Server 2005/2008/2012 Integration Services

Business Intelligence Tools: SQL Server 2005/2008/2012 Business Intelligence Development Studio

Programming Languages: T-SQL,C#,.NET

Reporting Tools: SQL Server 2005/2008/2012 Reporting Services

Development Environment: Visual Studio 2005/2008/2012

Operating Systems: Windows XP/2003/2008 Server, Win 3.x/95/98, Vista, Win 7

Advanced Excel: V-lookup, Sub-total, Pivot table, and Chart.

Environment: Agile Sprint & Hybrid

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

BI Developer (SQL Developer Report writing/Business Object 4.1)

Responsibilities:

• Experience in the field of SAP Business Object 4.1, Universe Designer, Web reporting, Dashboards Design.
• Migrate to different environments, designing Web documents and maintains them on Business Object.
• Experience in developing and maintaining business object reports, universe and metadata
• Development of dashboards and critical reports working with business analysts and business users to understand business requirements.
• Worked with testing team to help validation of reports and also to fix defects.
• We process data from Oracle database, flat file using SSIS into the reporting database.
• Created complex reports by linking data from multiple sources, using functionalities like combined Queries, Drill Down, master Detail, filters, Ranking Sections, Graphs, and breaks.
• Develop Web report (on demand, AdHock Reports, Frequency Reports, Summary Reports, Sub Reports, Cross-Tab)
• Supporting and maintain the Association Management System (AMS) of the organization by development and maintenance of the AMS, writing queries and reports, maintaining data integrity, and maintaining documentation.
• Implement any needed design, development, or maintenance of Personify database (SQL,.NET, Visual Studio)
• Develop and implement integration between systems using API/web service, Create and modify the query and reports utilizing Business Object Data Analyzer and Crystal Report.
• Assist with database and application upgrades and routine maintenance, Assist with user acceptance testing and implementing new database functionality in Personify or other systems
• Maintain data integrity in Personify, create and maintain documentation and standard operating procedures, Oversees administration of in-house and hosted SQL server
• Involved design and development of hospitals dashboards, which provides sales information by product and period//Month, KPI’s are Revenue, Volume, and price
• Worked on development of search light dashboards, which is used to evaluate the claims paid to the hospital. This is a critical report which is viewed by top management to take decisions and claim amounts.
• Worked on optimizing the performance of dashboards by sourcing data from scheduled instance of web report.
• Work with both Operational database and data warehouse to pull a report by using different join.
• Created database tables, wrote stored procedures for developers and users created SQL scripts and user define functions, check constraints, indexes, and views created triggers to enforce data and referential integrity.
• Writing select statement insert in to update statements use join frequently and validate values in excel use pivot table.
• Review the current procedure of backup and restoration, and take differential backup into the system and periodic restoration of backups.

Confidential, Silver Spring, MD

MS BI DEVELOPER

Responsibilities:

• Worked on tall phases of this implementation from gathering requirements to testing implementing and support
• Responsible for developing support and maintenance of the ETL (Extract, Transform, and Load) using SSIS.
• Developed several generic SSIS jobs which can be reused for several processes and working on data staging.
• Designed and developed complex mappings that involved slowly changing Dimension, Error handling Business, logic implementation.
• Created sessions, workless, workflows for the mapping to run daily biweekly and monthly based on the business requirements.
• Developing data stage cleaning data making validate with stored procedure and placed on the production server.
• Experienced in troubleshooting fixing bugs and addressing production issues and performance tuning.
• Extract data from flat file source using 3rd party tools encrypted, compressed and sent to remote data warehouse staging location via FTP.
• Work on encrypting and compressed with the TF PGP and TF compression task.
• Prepare ETL Specification, creating mappings, Teradata Scripts for extraction, transformation, and loading of data to the data warehouse.
• Created Connected, Unconnected and Dynamic Lookup transformation for better performance.
• Developed complex mapping logic using various transformation like Expression, lookups (connected and unconnected) Joiner and Filter Sorter Update strategy Sequence generator, Rank aggregator SQL XML Stored procedure and Normalizer.
• Created Sessions and portioned using different portion types like key range partitioning.
• Worked with ETL Migration Team and Migrated folders from Dev to Test repository and from Test to prod Repository.
• Performed Folder/Object Level Migration using Repository Manager.
• Designed, developed and tested data conversion /data integration modules to support large scale system migration and implementations.
• Used change data capture (CDC) for data integration that is based on the identification, capture, and delivery of the changes made to enterprise data sources.
• The tuned performance of informatics session for large data file using portioning increasing block size data coach size sequence buffer length and target based commit interval.
• Performed cleaning validating scrubbing, Sorting merging of the data.

Confidential, Silver Spring, MD

ETL/ SSRS Developer

Responsibilities:

• Involved in gathering business requirements and Installation and configuration of SQL Server.
• Created database, tables, writing stored procedures for developers and users.
• Created SQL scripts and defined functions, check constraints, indexes, and views.
• Created triggers to enforce data and referential integrity.
• Create new SSIS package (2008R2) to extract the date from legacy to SQL Server objects.
• Extensively used SSMS and SSIS Import/Export system for performing ETL operations.
• Performed data conversion from a flat file and excel into a normalized database structure.
• Developed, monitored and deployed SSIS packages (2008R2) and Configured Server for sending automatic emails and
• Generated Snapshot, Drill Down, and parameterized reports using SSRS
• Prepared Ad-hoc reports through report builders and published through Report Manager.
• Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users in report manager and server.
• Design and created different types of reports like Sub Reports, Drill-Through, Cascading, Drill - Down, ad-hoc Reports in visual Studio and deploy and manage on Microsoft SQL Server Reporting Services Configuration Manager.

Confidential

SQL/ ETL Developer

Responsibilities:

• Designed and developed the databases.
• Created store procedures, views, Triggers DML /DDL, and tables, generated TSQL script for the application.
• Business Intelligence Development Studio (BIDS) to create, edit, and deploy SSRS and SSIS.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008R2 using report manager and the report server.
• Created ETL packages using SSIS to extract data from the relational database and then transform and load into the database.
• Developed deployed and monitored SSIS packages including upgrades DTS to SSIS.
• Developed, executed, documented, and maintained appropriate BI procedures Scheduling Jobs and Alerting using SQL Server Agent.
• Collaborated with network operators, application developers, and DBAs to enhance end user experience.