PROFESSIONAL SUMMARY

• Over 12 years of full - time experience in Business Intelligence as BI Developer in data modeling, development, and maintenance of database applications on SQL Server in OLTP/OLAP/BI environment.
• Expert in business intelligence using Microsoft technology: SQL Server 2012, SQL Server 2008, SQL Server 2005, Analysis Services SSAS, Integration Services SSIS, Reporting Services SSRS. Also, in basic level T-SQL advance level T-SQL in different version of SQL server.
• Well-versed knowledge of SQL profiler and Query analyzer to enhance performance of SQL server by tracing and tuning the query.
• Expertise in building complex cubes using SSAS SQL Server Analysis Services by implementing dimension table and fact table either form of Star schema or Snow-flex schema.
• Skilled in implementing Calculations, Perspective, and Key Performance Indicators KPI, also providing the cube solution in Excel file for slicing and dicing the data and analyze KPIs across various dimensions.
• Experienced in developing ETL packages using SSIS SQL Server Integrated Services. Developed those packages bringing data form various heterogeneous sources like: Oracle, SQL server and OLEDB sources. Also did transformations like Execute SQL Task, Conditional Split, Merge, Lookup, fuzzy Lookup and Slowly Changing Dimension while loading the data into destination.
• Good experience in maintaining batch Logging, Error logging with Event Handlers and configuring connection managers using SSIS. Packages. Plus implemented Checkpoints, Break points to make the packages dynamically work.
• Implement migration SQL Server databases, user logins, and DTS packages from one server to another with help of Configuration files.
• Highly skilled in designing complex reports such as Drill-down, Cascading, Matrix, cross tab, and Map reports using SSRS SQL Server Reporting Services tools. Plus, build ad-hoc reports using SSRS 2012/2008R2/2008 based on specific client or manager's requirements.
• Extensive experience in building and deploying complex packages like: File Share System, E-mail additionally has knowledge about Subscription and Snapshot.
• Worked on Power BI and prepared dashboards using Tableau to make it more attractive.
• Detail-oriented, versatile adaptable in new environment, with strong interest in learning new technologies.
• Excellent Experience in installing, upgrading, and configuring Microsoft SQL Server 2012/2008R2/2008/2005 and with 24/7 standby troubleshooting support.

TECHNICAL SKILLS

ETL Tools: Talend Suite 5.x/6.x, Informatica 7.x/8.x/9.x, SQL Server Integration Services (SSIS)

BI Tools: SSRS, Power BI, Tableau, SSAS, Qlikview, Business Objects, Crystal Reports

Data Quality Tools: Dataflux, Trillium, Talend EDQ, Oracle Enterprise Data Quality (OEDQ), Informatica IDQ

Databases: Oracle 10g/11g, MS SQL Server 2005/2008/2012 , Mongo DB, Sybase ASE 11.5/12.x/15.x, IBM DB2, Mainframe, IMS, My SQL, MS Access

Tools: Mantas, Actimize, Embarcadero DB Artisan, Rapid SQL, Toad, TAC, Autosys, Control M, Gupta SQL, Power Builder, Oracle Forms & Reports, Sybase Open Client, SQL*Loader, SQL* Plus, Erwin, ER Studio, Power Designer, Visual Source Safe, Clearcase, Winrunner, MS Office, MS Project, Visio, Remedy

Programming Languages: SQL, PL/SQL, TSQL, Transact SQL, NoSQL, SAS, Unix Shell Scripts, Perl, VBA, VB Script, VB 5.x/6.x, Excel Macros, C, XML, HTML, XUL, ASP.NET, Javascript,J2EE

Operating Systems: Sun Solaris, Linux, Windows NT, HP - UX, UNIX, MS DOS, Mac OS X

PROFESSIONAL EXPERIENCE

Confidential, Kenilworth, NJ

SQL BI Developer/ Power BI/ Data Analyst

Responsibilities:

• Responsible for creating critical compliance test analysis documents and Business Requirement Documents (BRD).
• Created the Complex SQL Queries, User Functions, stored procedures, CTE’s, Views, Indexes also created schema and Tables Using SSMS 2018.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.
• Working on live site issues to fix slow running stored procedures, triggers etc. and provide Root cause analysis.
• Experience in Data Analysis, understanding trends and patterns in data.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, various other data sources to MS SQL Server by developing SSIS (SQL Server Integration Services) packages.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages to implement error/failure handling with event handlers, row redirects, and loggings.
• Created SSIS packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server Analysis Services (SSAS).
• Developed data visualizations and dashboards using Power BI and Tableau
• Extensively involved in SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
• Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.
• Wrote calculated columns, Measures query is using DAX in Power BI to show good data analysis techniques.
• Involved in scorecard and KPI Reporting.
• Designed Tableau and Power BI dashboard which give a visual representation for the users on MTD sales growth, Visual analytics on injuries, dealer location map etc.,
• Worked on various visualization techniques in Tableau like Scatter Plots, Histogram and Heat Maps.
• Created different tabular reports using Power BI features and enhanced them based on user requirements.
• Utilized Power BI to design multiple scorecards and dashboards to display information required by different departments and upper level management.
• Installed and configured on premises gateway in Power BI services.
• Scheduled Automatic refresh and scheduling refresh in Power BI services.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
• Published dashboards on an intranet site using SharePoint Server.
• Collaborated with different stakeholders from various business units to validate and approve compliance tests independently.

Confidential, Wilmington, DE

SQL Developer/BI Developer

Responsibilities:

• As part of the team, worked closely with DBA's to develop database and data warehouse with installation, configuration, performance tuning, optimization, backup, and recovery in SQL Server.
• Involved in creating Tables, Stored procedures, Views, Functions, Triggers, and user profiles in SQL server.
• Used SQL Profiler, Query Analyzer to enhance performance of SQL server by tracing and tuning the query.
• Developed simple or complex cubes in SSAS SQL Server Analysis Services with Dimension table and Fact table either form of Star schema or Snow-flex schema.
• Worked on developing cubes with Derived column, Aggregation, KPI for decision-making, Prospective, measures and hierarchy.
• Created MDX queries to retrieve data from cubes and to display SSRS SQL Server reporting services.
• Proficient in creating ETL packages, extracting data from various heterogeneous sources like: Oracle and SQL server and transformed it using different transformation as Lookup, Fuzzy lookup, and Slowly Changing Dimension SCD.
• Developed reports like: Tabular reports, Matrix, Drill down, Drill through, Cascading and Map using SSRS SQL Server reporting services.
• Created Ad-hoc reports and reports with complex formulas based on managers requirement or client requirement.
• Worked on to build deploy Reports, managing Subscriptions, and creating Snapshot also Report cache.
• Expertise in error handling. Making the packages dynamically work by implementing Checkpoints, Break points, Data Viewer, Securing packages and managers.
• In-depth knowledge of working and implementation of Crystal reports 9.0, Converting Crystal reports to SSRS SQL Server Reporting Services.

Confidential, NY

Analyst/Report Developer

Responsibilities:

• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provided accurate information for the Decision Makers.
• Involved in Designing and Creating various Projects in Framework Manager.
• Involved in Designing Models using Framework Manager.
• Involve in testing and verifying model if the results of queries are accurate.
• Created and Published Packages using Framework Manager.
• Set user roles, define governors, and set access authority for the packages to different users.
• Created report using Query Studio and Report Studio component of Cognos 8 BI.
• Trained End Users in developing the Ad Hoc reports using Query Studio.
• Developed Standard reports, Charts, Drill through Reports, and Master Detail Reports using Report Studio.
• Responsible for the delivery of solution-oriented complex reports using Cognos Report Studio.
• Developed filters, calculations, prompts in different reports to customize reports according to reporting requirement using Report Studio.

Confidential, Cambridge, MA

Business Intelligence Developer

Responsibilities:

• Worked with business users to determine business requirements, priorities, define key performance indicators, and develop Business Intelligence solutions and Data Warehouse strategies.
• Established, connected, and maintained JDBC, BMC Remedy, Google Analytics, SharePoint connectors to trigger data from Yellowfin transformations and data sources.
• Extracted data using Yellowfin ETL Transformation from Oracle, SharePoint, Google Analytics, XML, and flat files, perform transformations and populate the data warehouse for reporting.
• Used SQL queries to mine data from Oracle data warehouse and combine this data with other static data files.
• Data cleaning of Flat files, Google Analytics and SharePoint data in Python using Pandas and Numpy libraries and exporting into CMDB database.
• Developed and designed various statistical reports and dynamic dashboards to highlight data analysis trends and various analytical KPIs as per business requirements.
• Automated numerous manual tasks and reports using BI, SQL queries, functions which cut the cost and time by 90 percent.
• Created various events like Broadcasting reports and emails, FTP Schedulers, Timeline and Decision-making events in BI.
• Deployed and supported the Reports, Dashboards and ETL Transformations through various phases of Software Development Lifecycle and manage product delivery by agile methodology.
• Participated in sessions with management, SME, vendors, users, and other stakeholders for open and pending issues, involved in reviewing/analyzing business requirement documents (BRD) / functional specifications/use cases.

Confidential, Waltham, MA

Business Intelligence Developer/Analyst

Responsibilities:

• Managed all phases of business intelligence projects from conceptual design to implementation and training.
• Designed and configured SharePoint site for Business Intelligence Reporting Services, Performance Point, Excel Services, and Power Pivot applications.
• Created and managed all business intelligence site content, reports, dashboards, analytics, forms, workflows, libraries, data sources, and security.
• Responsible for elicitation and documentation of requirements for the development and enhancement of data warehouse, reports, dashboards, business applications, and business process initiatives.
• Created data models to document and define data requirements, business rules and system integration efforts.
• Created SSIS packages migrating data from various data sources and applying various data transformations.
• Created and managed Visual Studio Data Warehouse project staging, development, and production environments.
• Scheduled jobs for executing SSIS packages and Pre-Post Office processes to function orderly and smoothly in multiuser environment.
• Created SSRS Tabular, Matrix, Chart, Linked, Sub, Drill-down, Drill-through and Parameterized Reports for Finance, Manufacturing, Supply Chain, Technical Operations and Customer Services departments.
• Developed SSAS cubes, tabular models, MDX/DAX queries, Performance Point, Power View, Power Pivot reports and dashboards.
• Implemented and managed Tableau data analytics environment. Created data extracts, connections, and dashboards. Provided administration and training. Developed and maintained Total Operating Performance dashboard providing easy navigation to key metrics.
• SQL Server Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

Confidential, Boston, MA

BI Analyst/Data Analyst

Responsibilities:

• The project involved upgrading the current SMART system for Confidential from legacy system to a web-based application, creating reports and dashboards.
• Involved in different aspects and development stages of the overall solution and database architecture and setting up of the development and testing guidelines.
• Participated in daily stand-ups, sprint planning sprint reviews and sprint retrospective on a regular basis and reviewed tasks and user stories and provided estimates in JIRA.
• Interacted with the users and conducted meetings to understand the report requirements, to know their Business views and the level of detail needed by them and worked on data mappings.
• Performed a few proofs of concepts for the reports to determine the right platform. Created several report mock-ups for the users to demo and finalize the requirements.
• Created multiple SSIS packages to import data from the legacy (mainframe) system, Oracle, and Mongo DB to target SQL Server DB for report consumption and other use.
• Analyzed data in the existing databases and a thorough data quality analysis and profiling to identify anomalies and scrub and clean the data.
• Created SQL scripts, stored procedures, common table expressions (CTEs), functions and ETL flows to extract, clean, scrub and load the historical data in the existing system to the target tables. Creation of data lakes and data marts.
• Created multiple, overly complex reports in SSRS and Power BI, that run on high volume of data, with response time less than a few secs and which pulls data from SQL Server as well as Mongo DB.
• Created multiple highly interactive Power BI and SSRS reports for supervisors and managers, which enables them to see the status of the work, shift allocation for the next day at location, district, and borough level.
• Developed key reports in SSRS which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Scheduled of data refresh on SSRS reports on weekly and monthly increments based on business change to ensure that the views were displaying the changed data accurately.
• Extracted and imported data from MongoDB and configuration of the MongoBI connectors and the ODBC driver to enable smooth communication between MongoDB and SSRS and Power BI
• Created multiple Power BI dashboards and data visualization reports for DSNY supervisors and users to give them zone wise availability of the resources.
• Generated dashboards with key indicators for the daily planning team to enable them to plan the resources, in term of tasks, routes, personnel and their allocations.
• Used Power BI power query to extract data from external sources and modify data to certain format as required for consumption in the dashboards.
• Scheduled data refresh for Power BI dashboards on periodic basis to enable the display of the most current data on the dashboards.
• Deployed SSRS reports and published Power BI dashboards to share them with the appropriate users. Created multiple roles, with appropriate privileges for different users.
• Involved in performance tuning and optimization of the complex SQL queries and stored procedures. Created appropriate indexes, scheduled jobs for updating stats on the tables to keep the queries efficient.
• Involved in troubleshooting of the issues and coordinated with the QA team and other teams for bug fixes and deployment of the report. Created tasks to track the bugs, fixes, and their resolution, which helped in improving the overall development time.
• Involved in design, development, testing and support of the BI reports. Involved in debugging and monitoring and troubleshooting performance issues during the release and the weekly runs.