SUMMARY

• More than 5 years of industrial experience in all phases of the Software Development Life Cycle (SDLC) of a project which includes requirements gathering, analysis, design, development, maintenance & enhancement and testing.
• Extensive experience in working with both Methodologies - Agile, Waterfall.
• Experience in working within bigger as well as smaller teams
• Hands-on experience in database design and development in writing T-SQL Queries, stored Procedures Extended Stored Procedures, Triggers, Cursors, Indexes
• Basic knowledge of Data warehousing
• Extensive experience of Business Intelligence tools to perform analysis, design, development, testing and implementation of the reporting and ETL components
• Experienced in development and design of reports and dashboards for supporting the business analysis in a corporate wide reporting using Business SSRS, SSIS, SSAS, Tableau, OBIEE and SAP Crystal Reports
• Strong Database experience in Oracle PL/SQL, MS SQL, My SQL and DB2
• Strong understanding of data warehousing concepts, OLTP, OLAP, Normalization, Star and Snow Flake data models
• Basic knowledge of programming language like Visual Basic, ASP and C#.NET
• Working knowledge of SharePoint
• Demonstrated ability in being a team player as well as motivating a team to efficiently execute projects. Ability to learn new technologies quickly
• Experience in designing, developing and maintaining the enterprise based, multi-tiered client-server and distributed components applications using Core Java and J2EE technologies.
• Experience in developing Professional websites using Photoshop, HTML5, CSS3, and JQuery, JavaScript

TECHNICAL SKILLS

ETL: Visual Studio, Business Intelligence Studio, SQL Server Integration Services (SSIS), SQL Server, ETL, Data Mining, Data mart, OLAP, OLTP, Informatica Power Mart.

BI & Reporting: Management Studio 2014, SQL Server Reporting Services (SSRS), Power BI, Tableau, Microsoft Visio, OBIEE, SAP Crystal Reports, Excel Macros, Power Query, Power Pivot

Machine-learning languages: Python, R

Database: Microsoft SQL Server, MySQL, Oracle DB2, PL/SQL

Programming languages: T-SQL (5 yrs.) Core JAVA, J2EE, JSP, Servlets, HTML5, CSS2, CSS3, XML, C#.NET (2 yrs.) Vb.NET, Visual Basic, ASP.NET, SharePoint, R (<1 yr.)

Development Tools: NetBeans, Eclipse 3.x

Scripting Languages: JQuery, Java Script, AJAX, CSS, VBScript

Version control: SVN

Other Software: Photoshop, Fireworks

Testing tool: Selenium.

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst

Confidential

Responsibilities:

• Responsible for translating the Business requirements into technical specifications
• Analyze data flow and business requirements to create High Level Design and Low Level Design document.
• Create processes through MS Visual Studio (SSIS, SSAS, and SSRS) and MS SQL Server to develop a data warehouse project.
• Design, develop and implement BI solutions for reports
• Develop and understand complex SQL queries
• Coordinate changes required to facilitate the BI solution with analyst team
• Interpret, analyze, and appropriately assign data from large data warehouses for reporting services.
• Extract, transform and load external data sources into SSMS for BI solutions
• Create, update, and delete tables and views used for SSRS
• Create parameter controlled stored procedures and UDFs for SSRS
• Create and maintain multi-parameter, drill through/down SSRS reports and Ad hoc reports with data driven subscriptions
• Load data from flat files and excel sheet into Oracle database using SQL*Loader.
• Apply technical skills using SAS, Tableau and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner.
• Improve the performance of existing SSRS reports.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.

Confidential

Jr. Business Intelligence Analyst

Responsibilities:

• Involved in business requirements gathering along with Functional Team at client site.
• Creating browser enabled and administrator approved InfoPath forms in SharePoint 2013.
• Constructed data architecture using Database Systems principles in DB2, MySQL to build Normalized data architecture.
• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Created Dashboards to present critical company data in a single report.
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables
• Developed and maintained complex SQL queries, stored procedures, and data driven subscriptions for reporting purposes
• Developed SSRS reports and configured SSRS subscriptions
• Maintained and converted existing Crystal Reports to SSRS
• Evolving as part of a team, involved in Team Building, Strategic Planning, and Resource Management, Deadline Management activities to ensure Team’s growth and meet the delivery timelines.

Confidential

Software Developer

Responsibilities:

• Developed, tested and integrated applications for project. Worked under applications like legal heir, birth certificate, death certificate, etc.
• Extensively used JQuery library to provide rich interface experience like Animation, Fading, Hide/Show, Toggle, AJAX Form Submission, AJAX Data retrieval, Tabs, Accordion, Banner Rotator, Image Slideshow, Expand-Collapse and many other UI enhancements.
• Develop Web Sites and Web Applications as identified by Products and Marketing dept.
• Developed application using OOAD principles to have robust architecture. Used Java/J2EE as a language, ECLIPSE as an IDE for better and faster development.
• Performed regression, integration, platform and performance testing to certify the stability and usability of software systems.
• Planned, developed and administered previous version of organogram to detect and diagnose errors and bugs for the new improved version
• Provided input in database design and technical design to ensure the development of robust and extensible solutions
• Involved in QA testing along with testing team using Selenium Tool and ensured the quality of the product

Confidential

Web Developer

Responsibilities:

• Created, modified and extensively used CSS to provide uniform look and feel to portals and website.
• Extensively used JQuery library to provide rich interface experience like Animation, Fading, Hide/Show, Toggle, AJAX Form Submission, AJAX Data retrieval, Tabs, Accordion, Banner Rotator, Image Slideshow, Expand-Collapse and many other UI enhancements
• Used MYSQL to create database tables, commands, and queries and used other tools as required.
• Troubleshoot and corrected Cross Browser Compatibility issues and made sure web behavior was same for all major browsers namely IE9/8/7/6, Chrome, Safari (Mac/iPhone/ipad) and Firefox.