SUMMARY

• Senior IT Consultant with 8+ years of experience in Install, Design, Configuration, Development, Testing and implementation of Data warehousing and Business Intelligence Applications.
• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Experience in BI Development and Deployment of DTS, SSIS packages from MS - Access, Exceland Oracle.
• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
• Solid experience in Data Warehousing Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling, Physical Modeling, Dimension Data Modeling
• Migration experience from MS SQL Server 2010 to MS SQL Server 2012, MS SQL Server 2012 to MS SQL Server 2014.
• Experience in developing store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.
• Excellent Experience in monitoring SQL Server Performance tuning in using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.
• Extensive experience in analyzing and interpreting data, producing clear and compelling reports for different audiences using SSRS.
• Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
• Hands on experience in various Reporting technologiesTableau, Power BI, TIBCO Spotfire
• Good Knowledge ofSalesforce, Google Analyticsapplications
• Hands on experience using query tools likeTOAD, SQL Developer, PLSQL developer, TeradataSQL Assistantand Query man
• Experience in all Testing Phases: Unit testing, Integration Testing, Regression testing, Performance testing.
• Expertise in Data warehousing and Data migration.
• Extensive experience in loading high volumes of data.

TECHNICAL SKILLS

Operating Systems: Windows, Unix, Linux, IOS

ETL Tools: SSIS, Data Stage

Reporting Tools: SSRS, Power BI

Databases: Oracle, SQL Server, Teradata

Cloud Platforms: Amazon (EC2, S3 etc) and Google Web Services, Salesforce.com, Microsoft (Azure)

Data Modeling Tools: Visio 2010

Programming Language: C/C++, T-SQL, PL/SQL

ComputerApplications: MSOffice2014,AdvanceEXCEL, Share Point, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

IT Consultant

Responsibilities:

• Extracted data from various sources like SQL Server 2012/2014, Oracle, .CSV, Excel and Text file etc.
• Worked closely with application team, manager and other DBA’s for planning and implementation of the migration.
• Did Migration of the data from DTS to SSIS packages.
• Created Data-driven Packages in SSIS as part of the automating the process for the Referral Process.
• Installing and Configuring Reporting Services on Clustered Environment for High Availability.
• Analyzed reports to find out pattern for more efficiencyand worked on front end module using R, Amazon redshift server.
• Performed systems design, feasibility and Cost-Benefit Analysis and recommend cost-effective cloud solutions.
• Created packages with a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Lookup, Multicast and Data Conversion.
• Used advanced features ofT-SQLin order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner
• Designing& building databases to store information and monitoring performance of the database. Managing security of the data and ensuring accuracy of the data.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designingParameterized Reportsfor generatingAd-Hocreports as per the client requirements.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Performed data extraction and migration activities for populating test (or non-production) databases.
• TrainedEndUsersandPilotUsersaboutMicrosoft Reporting Tools.

Confidential, Warren, NJ

ETL Developer

Responsibilities:

• Designed SSIS packages to load data from different sources Text files, Excel to staging and staging to Data warehouse
• Applied different transformations Lookups, Data Conversions, Conditional Split and Derived Column to easily migrate SSIS package from one server to another
• Implemented the concepts of Incremental Data Load, Slowly Changing Dimensions for updating and maintaining the history of the records
• Involved in maintaining the Logging for the SSIS packages
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations
• Scheduled the ETL Process using Jobs. Created Alerts for successful and unsuccessful completion of scheduled jobs in SQL Server Agent.
• Data Definition and Data Manipulation Languages (DDL, DML) implementing constraints and triggers for data integrity in development of database for warehouse system
• Performance Tuning of Queries and Stored Procedures by using Execution Plan, SQL Profiler and Database Engine Tuning Advisor
• Worked extensively in writing and debugging complex Stored Procedures, Triggers, Views and User Defined Functions
• Created Charts, Tabular and Matrix reports using SSRS, with/without Drilldown
• Generating reports that can handle Dynamic Grouping and Dynamic Sorting
• Creation of Clustered and Non-Clustered Indexes for query performance and generated various reports using complex stored procedures
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages and PDA as well as window messengers.
• Provided Knowledge transfer to external organizations on basic data analysis skills, providing visibility to primary business performance.

Confidential, TX

SQL Developer

Responsibilities:

• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Implemented database standards and naming convention for the database objects.
• Involved in creation of new database, planning the location of data, index and transaction log files on the disks.
• Implemented new T-SQL features added in SQL Server 2005 that are Error handling through TRY-CATCH statement, Common Table Expression (CTE)
• Developed the reports in the form of Table, Matrix, Text and Chart Using SSRS (SQL Server 2005 Reporting Services).
• Generate the Snapshot Reports for each subject area according to client requirements.
• Developing parameterized reports including multi-parameters.
• Developed the reports with Drill-Down features.

Confidential, AR

SQL BI Developer

Responsibilities:

• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into Data Warehouse.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule SSIS Packages.
• Used Event Handlers for Exception Handling in SSIS packages.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Generated reports on wealth information, account information, research reports using ad hoc reporting to be used by the clients and advisors.
• Identified and worked with multi-value parameters for parameterized reports in SSRS.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Modification of database object such as addition of triggers, modification of table, stored procedure to meet new customer's requirements
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Generated ad-hoc reports using MS Reporting services.
• Worked on formatting SSRS Reports using the Global variables and expressions.
• Scheduled, maintained, and supported the distribution and access to reports at Server.