SUMMARY:

• Around 7 years of IT experience in RDBMS & Data warehousing, experience in OLTP and OLAP design, development, testing, implementation and support of enterprise data warehouse
• Worked with end - users/customers to understand business requirements, recommended technical solutions and documented functional requirements
• Experienced with full life Cycle phase of SDLC involving Systems Analysis, Design, Development and Implementation
• Excellent skills in designing Conceptual, Logical and Physical Modeling. Good knowledge in RDBMS concepts, data and dimensional models, Data Modeling in data warehouse environment Star/Snow Flake Schemas
• Worked on Oracle Data Modeler in several projects in both OLAP and OLTP applications
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User define data types, Cursors and Indexes using Complex T-SQL
• Experience in dealing with high volume transactional data in SQL
• Experience in Designing Business Intelligence Solutions with Microsoft SQL Server 2012 using MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS) and SQL Server Analysis Services(SSAS 2012)
• Experience in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, Sybase, excel sheets, Flat Files and MS Access
• Thorough knowledge of various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart
• Knowledge in Designing, Creating and processing of cubes using SSAS. Created and Configured Data Source and Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI's using SQL Server Analysis Services(SSAS 2012)
• Experience in the Reports generation by using Authoring and Managing Components of SSRS from both relational databases and OLAP Cubes.
• Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Experience in generating on- demand and scheduled reports for business analysis and management decisions using SQL Server Reporting Services (SSRS).
• Worked on creating client reports and custom reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Charts, Filters, Drill-down, Drill-through, dynamic grouping, Cross-Tab, graphical reports etc.) using SQL SSRS 2012.
• Prepared UNIX Shell Scripts and these shell scripts will be scheduled in AUTOSYS for automatic execution at the specific timings.
• Self-motivated, possesses ability for critical thinking, technically motivated and creative, experienced in working in technically challenging environments.
• Proficient in keeping abreast of new technologies, methods and techniques to understand how they might be applied to the client's environment
• Experience in Database Installation, Capacity Planning, Backup and Re-store for application and database.

TECHNICAL SKILLS:

SQLServer 2008, 2012: (stored procedures, functions, triggers, complex T-SQL queries, performance tuning and optimization, database design etc.)

MSBI: (SSIS, SSAS, SSRS)

Data Modeling Tools: Erwin

Language:: T-SQL, PL/SQL, C, Oracle 12c, 11g, 10g, MS Access, Python.

Operating Systems:: Windows 7/XP, Windows Server 2008, UNIX.

Application Packages:: MS Office, MS Outlook.

Database Tools: SQL Server Profiler, SQL Server Data Tools, BIDS.

Schedulers / Querying Tools: AutoSys Job Scheduler, MS Visual Studio, SQL Server Management, MS-Office.

PROFESSIONAL EXPERIENCE:

Confidential, Savannah GA

MSBI Developer

Responsibility:

• Involved in database development using stored procedures, triggers, views and cursors.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Created indexed views, and appropriate indexes to reduce the running time for complex queries to keep track of data manipulations using Audit functionalities.
• Communicating with the client through e-mail and telecoms on project requirements.
• Ensure knowledge sharing in the entire team.
• Design and Developing Automated UNIX Shell scripting for loading, running the mappings and validating the data in the data warehousing system.
• Wrote C# code where ever scripting is necessary especially to manipulate the files coming from UNIX box.
• Created several packages in SSIS.
• Custom components for SSIS packages were written in VB.net.
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
• Scheduled the packages to keep extracting the data at specific time intervals and shared location.
• Used various transformation tasks to create ETL packages for data conversion.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Developed Interfaces using UNIX Shell Scripts to automate the bulk load & update Processes.
• Used Autosys for scheduling the jobs.
• Generated custom and parameterized reports using SSRS.
• Created reports that call sub reports in SSRS.
• Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts, maps and Graphs.
• Responsible for creating datasets using T-SQL and Stored Procedures.

Environment: SQL Server 2012, MSBI, SSIS, SSAS, AND SSRS, UNIX, AUTOSYS.

Confidential, Columbus, OH

BI Developer

Responsibility:

• Involved in gathering the user requirements.
• Data migration (Import & Export using BCP) from text to SQL Server 2012.
• Involved in database backup, recovery procedures.
• Designed and implemented stored procedures and triggers for automating tasks.
• Identified the data source and defining them to build the data source views.
• Created SQL server Reports using SSRS 2012.
• Created Cross-Tab, Drill-down, Drill-down and Sub-Report using and linked reports using SQL Server Reporting Services.
• Involved in SSRS report deployment and report server configuration.
• Scheduled the reports to run automatically.
• Launching the report builder for adhoc reports.
• Configuring the report viewing security.
• Created schedules and subscriptions.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring during execution.
• Gained working knowledge of Autosys jils at command line for loading/force starting jobs, changing job status and monitoring job progress.

Environment: MS SQL Server 2012, MS SQL Server Reporting Services 2012, Windows XP.

Confidential, Dublin, CA

BI Developer

Responsibilities:

• Preparing the design document based on the requirements.
• Involved in designing of complex ETL solution based on the Customer need which involves various stages of the data flow from Flat File/SQL server source to staging area, cleansing the data, loading to the fact tables and then aggregating the data for reporting purpose. These ETL involve various transformations like SCD, Merge, Look-up, derived column, data conversion, multicast, union all transformations etc.
• Re-engineering the legacy ETL code to improve the performance of the code and also for easy Maintenance and also wrote ETL packages using SSIS.
• Also re-engineered the legacy ETL process by designing the enhancements to include bad data management & email notification (failure & success), effective logging.
• Attending the regular meetings with clients to understand the requirements.
• Experience in Transact-SQL and implementing business logic using Triggers, Indexes, Views and Stored procedures and creating alerts for successful or unsuccessful completion of scheduled jobs.
• Design and develop ETL mappings for loading the source data into the staging area and also for loading dimensions, facts and aggregate tables. Also, developed Unix shell scripts to copy the source system files and execute the ETL workflows and sessions.
• Used SQL Server Reporting Services (SSRS) for creating drill down, drill through etc. reports based on the requirements.
• Scheduled the reports to run on daily, weekly basis in the report manager.
• Design and unit test the reports using SSRS.
• Documentation of all the processes involved for future reference.
• Implementing and enforcing the process to the project.

Environment: MS-SQL Server 2012 (SSIS, SSAS, SSRS), TSQL, Visual Studio 2010.

Confidential, Pittsburg-PA

BI Developer.

Responsibilities:

• Interact with Business users and Technical SMEs to clarify requirements, review design, test cases and deployment.
• Designed and directed the ETL process, including data quality and testing.
• Created and modified Stored Procedures as per the business requirements.
• Worked on SSIS to integrate and analyze data from multiple heterogeneous information sources.
• Created Master/Child ETL Packages using SSIS control flow tasks and Dataflow tasks to extract data from OLTP for Data warehousing applications.
• Worked with different methods of logging, package configurations and event handlers.
• Created parameterized reports, Ad hoc and scheduled reports using SSRS and Report builder from OLTP and OLAP data sources and deployed on report server.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status. Trouble shooting Reports issues, ETL job failures and optimizing query performances.
• Involved in testing of the ETL components and Reports Ensure deliverables meet the quality standards.

Environment: Microsoft Business Intelligence Studio, SQL Server 2008, SSIS 2008, SSRS 2008, SSAS, MS Excel 2007

Confidential, Portland OR

BI Developer

Responsibilities:

• Understanding the Business and its Requirements.
• Involving in designing, testing for SSIS Packages.
• Involving in deploying and scheduling SSIS packages.
• Involved in various tasks such as Control Flow(Execute Sql task, For each loop Containers, Data Flow task, File System etc) and transformations such as Aggregate, Sort, Lookup,
• Merge join, Multicast, Conditional split, Derived column etc.
• Creating Table, matrix, drill- down and drill - through reports using SSRS.
• Involving in deploying Reports.

Environment: SQL Server 2008, SSIS, SSRS, SSAS

Confidential

BI Developer

Responsibilities:

• Installation and configuration of SQL Server Reporting Services 2008.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Involved in creating report models and applying row level security filters for report model.
• Developed Stored Procedures and Views to be used to supply the data to the reports.
• Complex formulas were implemented to get derived fields and format the data based on specific conditions.
• Experience in building reports through Report Builder and Report Designer.
• Experience in creating reports using Report Model and applying row level security filters.

Environment: SQL Server 2008, SSRS