Lead Data Analyst (Tableau,Cognos, DWBI,PL-SQL, Python and other BI solutions)
Dear HR, I have 11+ years experience which include, • Subject Matter Expert in Business Data Analysis to identify process gaps and bottlenecks and to provide insights which enables stakeholders and business to improve policies and operations. • Expertise in defining scope of projects based on gathered business requirements including documentation of constraints, assumptions, business impacts & project risks. • Performed extensive GAP analysis in transforming the regulatory documents to business rules. • Liaised closely with all Lines of Business and Technology teams for successfully implementing the regulatory projects • Successfully resolved the complex queries raised by the regulator (the Federal Reserve) on the reports submitted. • Initiated a program in the firm which helped in increasing the Customer Satisfaction Score by 40%. • Pragmatic experience of adapting new technologies, tech analysis/improvements, code reviews and multiple design patterns while developing enterprise application. • Proficient in planning, designing, developing and enhancing project architecture (which includes System improvement and resulting better user services). • Exhaustive experience of agile software development methodologies, technologies, tools, best practices and their trade-offs. • Extensive hands-on design & dev experience using various approaches TDD/DDD/BDD. • Displaying enthusiasm with structured thought, strong aptitude for thorough analysis and creative implementation. • Skilled consultant and strategist with skills in identifying business process needs, conceptualizing business solutions and implementing plans to achieve corporate goals and steering growth initiatives. • Internally motivated, self-starter with ability to plan, organize and establish priorities to meet goals and achieve results. • Hiring/team building: Prepared a strategy for my organization to improve the hiring process. • Possess lots of self-motivated initiative with a highly objective and result-driven mindset. • Having working exposure to collaborate with multiple cross geographical teams on daily basis. • Experience of Leading the Development teams and delivering quality products through implementing development best Practices and Methodologies. • Experience of software solutions for multiple business domains including Regulatory reporting, Travel & expense • Management, Hotels and hospitality, IT-IS, Life sciences, Real estate and Supply chain. • Worked on all different aspects of application - reliability, scalability, maintainability with required monitoring in place. • Think through the performance intricacies while considering or reviewing any design. • As Scrum master Ensures the team lives agile values/principles and follows the processes, practices that the team agreed they would use. • Help/guide team members while co-ordinating with different other downsteram and upstream teams across the globe • Work on POC for any new feature/integration • Understanding and hands on experience of integrating codebase with various code coverage, code style/formatting & automated security vulnerability finder • Keep on updating the team on new org-wise initiative and drive for exexecution, guide the team for understanding any new tech and their impact • keep pulling team members to improve the overall automated test coverage with infrastructure improvement • Work as a build coach and support team to handle tricky/complex production issues • Requirement Analysis, Design, Development and Deployment of Tableau and Cognos solutions for corporate/regulatory reporting needs. • Proactively migrated the projects to analytics platform using Tableau, Cognos, Composite, PL SQL and Big Data. • Developed Data model by writing logics and calculations in Python to integrate and transform data as per reporting requirement. • Developed mapping by writing Python scripts to map upstream source data with standard liquidity statement line and or liquidity coverage ratio report lines for regulatory reports. • Automated manual processes by creating dashboard/reports using Tableau /Cognos • Data visualization experience using Tableau. Development of the Dashboard reports as per business requirements and engagement with global/internal stakeholders. • Generated $10,000 savings by optimizing processes and building in house analytical tools using Tableau, Cognos and Oracle. • Generated $1.5 Million savings by automating manual user analysis (Excel macros) using TABLEAU. • Expertise in DWH, Data modeling (Relational/DMR, MDX/Cube modeling) using Cognos Framework manager and Transformer/Cube designer. • Expertise in ETL, SQL Stored procedure, SQL package, Load script, performance tuning, data cashing. • Very good experience in data transformation from one form to another i.e. XSLT, XML, JSON, Tabular, Streaming, unstructured data etc. • Graduate in Statistics and experience in statistical analysis. • Ability to learn new technologies quickly and deliver best as per business requirements and transform numbers to Business Insight. There are many more points to discuss on personal and professional front. Looking for an opportunity, which will give more such feathers to my wings and will be more rewarding. Regards, Ashish Singh