SUMMARY

• Around 8+ years of IT experience in Analysis, Design, Implementation and Administration of Business Intelligence Solutions with Microsoft SQL Server 2016/2012/2008 in various domains like Financial and Telecommunications sector.
• Experience in Agile/Waterfall project methodologies in Analysis, Design, Development, Testing and Implementation of client - server based applications.
• Excellent SQL, T-SQL Development Skills to write Complex Queries involving Multiple Tables & to Develop and Maintain Stored Procedures, Triggers, User Defined Functions, Views.
• Experience in writing complex SQL queries involving Inner and Outer joins, Temp Tables, Global Temp Tables and UDF’s.
• Proven ability in Performance Tuning (SQL Query/Stored Procedure Tuning), Query Optimization, troubleshooting.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents (BRD) and plans for creating interactive dashboards.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions, for various fact calculations for efficient data visualization in Power BI.
• Comfortable in working with filters/calculated columns/measures/relationships and transformations of Query Editor Section.
• Published/shared the reports by creating Content Pack/Sharing the Pbix file.
• Experience in creating complex queries using self joins, subqueries and CTE’s.
• Utilized Power BI (Power Pivot/View) and DAX functions to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Extensive experience in T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS and Data Warehousing.
• Adept at creating Simple to Parameterized Dynamic Reports and Complex Reports including Tabular Reports, Matrix Reports, Charts, Graphs and Sub-reports using SSRS in Business Intelligence Development Studio (BIDS)/Data Tools.
• Experience in Creation, Configuration, Development, and Deployment on various servers of Reports using SSRS.
• Deployed the packages on staging and production. Monitored jobs and supported Azure Data Lake production environment.
• Have good understanding in Dimensional Data Modeling and Cube Development, designing of STAR, SNOWFLAKE Schemas, Partition, Aggregation and Optimization using SSAS.

TECHNICAL SKILLS

DBMS/RDBMS: MS-SQL Server 2016/2014/2012/2008, T-SQL, Oracle, Postgres, Snowflake

ETL: SQL Server Integration Services (SSIS), T-SQL using Stored Procedures, Informatica

BI Tools: POWER BI, SSRS, Visual Studio 2015, Oracle fusion

Version Control Tools: SVN, Git, Bitbucket, TFS

Languages: C++, PL/SQL, JAVA, SQL, Unix Scripting

Other: Autosys, Jil, XL-Deploy, B-One Application

PROFESSIONAL EXPERIENCE

Confidential - Los Angeles, CA

SQL/SSIS/SSRS Developer

Responsibilities:

• Requirements gathering, data analysis, design and development of the solutions to meet client’s requirement.
• Essential to have good understanding of Agile Methodology framework and use of JIRA for tracking the progress of development efforts.
• Creating and managing schema objects such as tables, views, indexes, stored procedures and triggers.
• Work on data transform from one server to other servers using tools like DTS/SSIS.
• Create UDP’s using cursor and call them based on the requirement, e.g. post running DI.
• Create data models and Reports using the data extracted from heterogenous sources and share the models with other stakeholders in the Organization.
• Work on Microsoft SQL Server Management Studio (SSMS) - Visual Studio, Integration Services Catalogs, SQL Server Agent, SSRS.
• Work on Cache transformations to finetune and improve the performance.
• Create SSIS Packages to extract data from different sources like Excel Files, XML, SQL Server and Oracle using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports.
• Supporting daily loads and work with business users to handle rejected data.
• Using UNIX Shell Scripts to automate the jobs to load data into B-One.
• Automate File Transfer Processes and mail notifications by using FTP Task and Send Mail task in packages.
• Use logging to capture run-time information about a package and utilize the details for audit and troubleshooting purposes.
• Responsible for performance tuning by determining bottlenecks at various points like targets, sources, mappings, Transformations and SQL Scripts.
• Involve in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Generate multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports; thus, making them user friendly.
• Use Refresh Now and Schedule Refresh functionalities to get the updated data from original dataset.
• Testing of components developed by other Developers.
• Production deployment using the application XL-Deploy and help, to fix issues on Unix Servers and python.
• Solve the deployment errors in both code and environment uses. Use Splunk Dashboard to monitor jobs, remote desktop and connect to Linux servers to check the errors.

Environment: MS-SQL Server 2012, Oracle12c, T-SQL, Toad, SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS), PL/SQL, Unix/Linux Scripting, Bitbucket, Agile, Jira, Bamboo, XL-Deploy, B-One, MS Excel, Delphix servers, Visual Studio 2015, SQL Server Reporting Services (SSRS).

Confidential - Deland, FL

SQL/SSIS Developer

Responsibilities:

• Worked on different tools like Microsoft SQL Server Management Studio (SSMS), Visual Studio, Integration Services Catalogs, SQL Server Agent, SSRS and python.
• Created SSIS Packages which perform transform operation using different transformations Lookup, Multicast, Sequence container, for loop container, Derived Column, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task etc.
• Handled Change Data Capture (CDC) data and improve the performance of the SQL code, packages.
• Involved in debugging the code with debugger to understand dataflow with help of data viewers.
• Created SSRS reports by providing parameters, so user can select values and run the report.
• Designed standard tabular type reports using SSRS.
• Worked on Unit and Acceptance testing after development, coordinate the deployment in Production, and provide hyper care support.

Environment: MS SQL Integration Services 2008, SSMS, MS SQL Server 2012, Visual Studio 2013, MS Excel.

Confidential - Plano, TX

SSIS/Power BI DEVELOPER

Responsibilities:

• Involved in SDLC of the project from requirements gathering phase to technical design, development and testing phase.
• Creating and managing schema objects such as tables, views, indexes, stored procedures and triggers.
• Worked extensively in writing and debugging complex stored procedures, views, and defined the constraints on the table columns to prevent data redundancy.
• Created Power Bi Reports in Power BI Desktop with various sources of data Like Excel, SQL server and CSV files as per the User Requirements.
• Designed different types of Visualizations like column chart and pie chart and KPI s and used slicers to filter the data by the user.
• Extensively used the DAX queries to build the Data Model in the backend to create calculated columns and Measures.
• Working with Power BI Service for creating Dashboards and sharing them to business users to monitor the business.
• Working with DAX formulae for creating variables like Previous Month, Previous Quarter, etc. and creating interactive visuals using geographic data.
• Worked extensively on SSIS packages to implement the data load strategy.
• Involved in designing, developing and testing ETL strategy to populate the data from various source systems feeds using SSIS.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2016.
• Created views and Stored Procedures for generating report. Responsible for creating the reports based on the requirements using SSRS.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.

Environment: Power BI Desktop MS SQL Server 2016/2008, DTS, Power BI, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, ETL, Red Gate SQL Source Control.

Confidential

SQL/BI Developer

Responsibilities:

• Created new databases and required tables as per the requirement.
• Created T-SQL queries, stored procedure for faster retrieval of data and to display specific information.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views.
• Designed ETL packages for integrating data from heterogeneous sources like Excel, CSV, Flat file and Text Format data and applied various data transformation like conditional split, look up, derived column, slowly changing dimensions.
• Used check point, break point and Logging in SSIS to debug and optimize package while developing them.
• Used Event Handlers to run the Send mail task in the background upon failure of SSIS package.
• Evaluated database performance and maintenance duties such as Backup, Restoration are performed by scheduling jobs using SQL Server Job Agent.
• Provided daily support to the client/technical teams for system wide tasks such as monitoring, alerting, testing, bug fixing/problem resolution & documentation.
• Scheduled and maintained nightly and weekly loads of data by creating and scheduling the respective jobs.
• Troubleshooted reports issues, ETL job failures, optimized query performances.
• Automated File Transfer Processes and mail notifications by using FTP Task and Send Mail task in packages.
• Used Event handlers to capture the run time error messages by using send mail tasks in the background upon success or failure of a package in SSIS, carried out scheduling and administering of SSIS packages.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Involved in error handling, creating package configuration and log details using SSIS logging.
• Developed, designed and deployed Matrix and Tabular reports with drill down and drill through features using SSRS in Business Intelligence Development Studio (BIDS) as per client requirements.
• Designed, developed and deployed Summarized, Matrix and Tabular reports with drill down and drill through features using SSRS in Business Intelligence Development Studio (BIDS) as per the client requirements.

Environment: MS SQL Server 2008 (SSMS), MS SQL Server 2012 (SSMS), MS SQL Integration Services, MS Word, Visual Studio 2008, MS Excel.

Confidential 

Jr Informatica Developer

Responsibilities:

• Designed, developed and deployed Summarized, Matrix and Tabular reports with drill down and drill through features using SSRS as per the client requirements.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformations, Informatica Repository Manager.
• Designed various mappings for extracting data from various sources involving flat files and relational tables.
• Involved in developing the mappings by using various transformations like source qualifier, sorter, aggregator, router, filter, lookup, expression etc.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Involved in preparing the Mapping design documents.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Involved in preparing the Unit Test Cases for various mappings and workflows.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Developed workflows by using various tasks like command task, session, decision task and e-mail task.
• Worked with the Informatica Scheduler for scheduling the delta loads and master loads.
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs.

Environment: Informatica Power center 8.6.1, Oracle 10g, Windows XP, Unix Shell Scripts, SQL, PL/SQL, Flat files.