SUMMARY

• 14+ years of extensive experience in Business Intelligence - primarily in Microsoft BI Stack, Business Objects, Tableau, Informatica and Cognos in various domains like BFS, Retail, Health Care, Operations and Logistics.
• Strong experience in working on projects using Agile/Scrum Methodology and Waterfall Methodology.
• Experience in all phases of Software Development Life Cycle.
• Strong understanding of Data Warehousing and Business Intelligence concepts and have sound analytical and problem solving skills.
• Strong Experience in SQL, PL/SQL in SQL Server and Oracle.
• Strong Experience in ETL tools - Informatica, SSIS for Data Loads
• Experience in Data Migration, Data profiling, Data Mapping and Data cleansing
• Good experience in translating business requirements to technical details and have good co-ordination skills with Customer as well as Project team.
• Have good experience in both development as well as Maintenance projects. Have good exposure to Onsite-offshore delivery model and client facing roles.
• Hands on experience working with modeling tools such as Erwin, Power Designer, E-R Studio and Visio
• Extensive experience in Universe Creation, WebI reports and Xcelcius Dashboards development and Administration in SAP BOE
• Experience in analysis with SSAS and creation of SSRS reports.
• Experience in Tableau, Power BI and Qlikview for data visualization, Dashboards, Reporting and Analysis.
• Good understanding of Big data and Cloud concepts.

TECHNICAL SKILLS

Reporting Tools: Business Objects, SSRS, Tableau, Crystal Reports, Cognos, Power BI

Integration Tools: SSIS, Informatica, DTS

Analytical Tools: SSAS, Excel

Relational Database: Oracle, MS SQL Server, Teradata, Vertica.

Scripting: SQL, PL/SQL, MDX Queries, VB Script, Python

Database Client: SQL Developer, SQLPlus, Toad

Other Tools: Visual Basic, PerformancePoint Server, MTS, Rational Suite, CVS, VSS

Operating System: Windows, Unix

PROFESSIONAL EXPERIENCE

BI Lead Developer

Confidential

Responsibilities:

• Coordinating with business to get the requirements.
• Driving daily Scrum meeting and reporting to stakeholders.
• Designing and development of SSIS packages, SSAS Cubes and Power BI Reports.
• Ensuring on time high quality deliverables.

Skills: SQL Server 2016, MS BI 2014 (SSIS, SSAS), Power BI, Jira, Service Now

BI Lead Developer

Confidential, Newark, CA

Responsibilities:

• Coordinating with different teams that manage the Data Center components and the business to get the requirements.
• Driving daily Scrum meeting and reporting to stakeholders.
• Creation of tables, views and Stored Procedures.
• Designing and development of Dashboard, SSIS packages and SSRS Reports.
• Ensure the data is up-to-date in Dashboard and metrics are accurate and is available on time.

Skills: SQL Server 2016, MS BI 2014 (SSIS, SSRS), PHP, ASP.Net, C#, Service Now

Confidential

Senior BI Developer

Responsibilities:

• Architecting and designing the system to generate the required reporting metrics.
• Leading the data analysis, development and implementation of the system and reporting metrics.
• Leading the development of SSIS packages, SSAS Cubes and SSRS Reports
• Integration of Reports in SharePoint
• Driving Governance calls with Stakeholders for Change Requests and Program Road Map.
• Coordinating weekly Production Build and Support.
• Providing Monthly Performance Reviews, ensuring quality deliverables, mentoring the team.

Skills: SQL Server 2012, SSIS, SSAS, MDX, SSRS, Power BI, PPS 2007, SharePoint, VM, Visual Studio 2012

Confidential

BI Lead/Architect

Responsibilities:

• Creation of Technical documents based on business requirements
• Creation of Mapping documents
• Data Modeling and Designing of Tables in Teradata.
• Planning and development of Informatica ETL jobs
• Creation of Universe, WebI reports and Xcelcius Dashboards based on existing Cognos Reporting system
• Coordinating with the offshore team for the Development, testing and Implementation.
• Providing Status Updates and Reviews with the client and team.

Skills: Teradata, Informatica, Business Objects XI R3, Xcelcius

BI Lead and BO Admin

Confidential

Responsibilities:

• Project Planning and Estimation.
• Requirements Gathering and Analysis at the client site.
• BO Administration and Coordination of Support and Maintenance activities.
• Ensuring availability of the system and applications.
• Support for SSIS production jobs and Business Objects Reports
• Administration of BO and Websphere servers
• Tracking and reviewing tickets or logs and driving them to closure.
• Advising and Architecting Service Improvements in the system.
• Driving Status meetings and Review meetings with the client.

Skills: BO XI R2, Websphere 6.0, SQL Server 2008, SSIS

BI Lead Developer

Confidential

Responsibilities:

• Requirements gathering at the client site.
• Coordinated with the offshore team to create the Exception Reports for Wire transfers that consolidate the incorrect transactions as per the regulation.

Skills: Business Objects XI R2, DB2

Scrum Master

Confidential

Responsibilities:

• Leading Sprints.
• Estimation and Planning of sprints.
• Driving Daily Scrum meeting.
• Daily Scrum and Reports review with client.
• Co-ordination and Managing Migration of Reports from BO to Cognos
• Conducting Sprint Reviews at the end of each sprint.

Skills: BO 5.x, Cognos 8, Oracle 8i