Ankur Sinha Email & Phone Number

Stockholm, Se

Stockholm, Sweden

• Serving as a consultant and leader for Data and Analytics application & platform architecture.• Development of Data warehouses, distributed systems and analytics platforms.• Utilizing Microsoft Azure cloud-based Data and Analytics platform solutions.• Driving technical design for large scale data platforms, utilizing modern and open source technologies in hybrid cloud environment.

Bangalore India

• Interaction with customer/client for functional and non-functional requirements gathering.• Requirement analysis, architectural designing and coding for analytics project implementation.• End to end Big Data & Data Warehouse project implementation which includes system analysis, database designing, dimensional modeling, coding, testing, upgrading existing system and performance optimization.• Designing & implementation of ETL process for data cleansing & extraction.• Development of reports and dashboards for analytical reporting & data analysis.• Development and maintenance of best practices and standards.• Supervising co-workers, reviewing solution design and helping in performance optimization.• Database activities such as development of stored procedures, functions, triggers, views, database backup and database recovery.• Experience in defining Security, Capacity and Reliability of visualization tool(Tableau).• Experience in Designing, development and support for Self Service environment for data discovery and ad-hoc reporting tools like Tableau & Power BI• Security Maintenance activities such as creation of logins & resolving security related issues.• Certified ScrumMaster (agile software development methodology).• Primary skills: =>MSBI Stack : SQL Server 2008, 2012, 2014, SSIS, SSAS, SSRS, Microstrategy, Visio, Tableau 9.0 & 10.0, TFS(Team Foundation Server) =>Big Data : MapR Hadoop Ecosystem - Spark-Scala, Hive, Drill, Kafka, Streamsets, Elasticsearch, Kibana =>Azure : Eventhubs,Databricks, Spark-Scala, Stream Analytics, Data Factory, ADLA, ADLS, Power BI etc

Bengaluru Area, India

•Client interactions and requirement gathering.•Architectural Designing & Implementation of Enterprise Data Warehouse.•System Analysis, Database Designing & Dimensional Modelling.•Designing & Implementation of ETL processes. •Creation of Multidimensional Cubes & OLAP models.•Reports and Dashboard Designing & Development.•Provides inputs on tool selection for efficient, high availability and fault tolerant systems.•Develop and maintain best practices and standards related to data integration.•Testing, performance optimization and solution deployment. •Effort estimation, code reviews and technical documentations.•Leads and supervises co-workers.•Development of stored procedures, functions, triggers, views as per business need using Oracle.•Database management and maintenance activities such as database backups and recovery.•Creation of logins and providing access to users as per roles and security assignment. •Working experience on MSBI Stack(SQL Server 2008/2012, SSIS, SSAS & SSRS), Analytic Server workbench, RPM & Oracle.

Pune Area, India

• Architectural Designing, Coding, Implementation and Team management.• Interaction with customers/clients for requirement gathering and conducting meetings.• Database designing & System Analysis.• Designing & implementation of ETL process using SSIS packages.• Designing multidimensional cubes using SSAS. • Creating SSRS Reports and publishing Reports on SharePoint Site.• SQL Server Database Optimization, Performance tuning and SQL Coding.• Troubleshooting and Performance monitoring using tools like SQL profiler.• Effort Estimation, Code Reviews, Unit testing and Technical/Design documentation.• Analysis of functional requirements and preparation of technical documentation.• Interaction with functional owners to identify business system requirement, evaluation of solutions and business problems and propose alternate methods and tools to optimize efficiency.• Database designing, dimensional modeling & system analysis for data warehouse projects. • End to end project implementation, testing, code modification and performance optimization of existing applications.• Development of reports for data analysis for BI (Business Intelligence).• Subject matter expert for providing technical assistance and guidance to peer groups and clients. • Database management/administration such as database backups and recovery.• Development of required Stored Procedures, User Defined Functions, Triggers, Views as per business logic using SQL Server.• Creation of logins and credentials as per user roles for security maintenance. • Co-ordinate with Team members on each deliverable and guide wherever required to maintain data integrity, policy and standards.• Act as change authorization lead and participate in Status meetings, Change management meetings to report issues/updates/decisions.

Usa

• Worked with esteemed clients like Intel Corp CA, Residential Credit Solution(RCS) TX,Cooks Children Hospital TX, Premera Blue Cross WA. • Worked Extensively on SQL Server 2008, Integration Services, Analysis Services and Reporting Services.• Involved in performing Extraction, Transformation and Loading using complex SSIS packages from various sources like XML, CSV, Excel, Oracle and SQL Server.• Developed all the required Stored Procedures, User Defined Functions, Triggers, Views using T-SQL as per business logic.• Used SQL Server 2008 Reporting Services (SSRS) for generating various different kinds of reports such as Tabular, Freeform, Drillthrough, Drilldown, Charts, Graphs, Cascading, Sub reports and Parameterized Reports.• Report Builder 2.0 used for creating business Model for the Ad-Hoc reports.• MDX queries utilized in both SSAS cube and to manipulate the SSRS Reports.• Created PPS Dashboard for the business using SSAS OLAP database and integrated with SharePoint.Worked extensively with client to understand their business requirements. • Analyzed organization's business requirements for database designing and implemented changes to database as required.• Designed, developed, modified, integrated business intelligence applications/solutions.• Created stored procedures, views and triggers for analytical reports. • Administered/Supported database backup, recovery, replication and mirroring procedures.• Implemented and maintained database coding standards, best practices and policies.• Provided end to end support for functional and performance testing.• Maintained and managed user permissions, logins and security issues.• Insightful experience to design activities, involving writing functional & technical specification documents for product enhancements.• Ensured proper designing, implementation, performance, availability, security, auditing and capacity management of related database systems.

Uk

• Responsible for tier 2 technical support for more than 10 servers in a mission-critical/production environment.• Resolved errors with the user/ customer accounts.• Optimized indexes to significantly improve queries.• Maintenance: Archived obsolete databases, applied service packs, and managed logins and user permissions.•Administered/Supported database backups and recovery with SQL Server 2000.• Maintained and managed user accounts, permissions, logins and security issues.• Technical documentation.• Ensured proper performance, availability, security, auditing and capacity management of related database systems.• Tools used: MS OFFICE 2003/2007, SQL Server 2000.

Bachelor Of Engineering (B.E.), Electronics And Telecom, University Ranker

Master Of Science (Msc), Information Technology, Grade A