BI Architect
2014 - PRESENTFreelance- Provided an architecture solution that was reusable, maintainable, and scalable.
- Leveraged AWS cloud services to build secure, highly scalable, and flexible systems.
- Built and designed real-time streaming from sensors, IoT devices to a data lake using Redshift, PI, Kinesis, Glue, Lambda, and CloudWatch.
- Implemented an S3 data lake for storage and Amazon Redshift and RDS for data organization along with Tableau/Power BI for data visualization.
- Built a data lake solution for high performance to enable analytics using S3, Redshift, Glue, Lambda, Athena, CloudWatch, CloudFormation, SageMaker, and other AWS services.
- Improved query performance on Redshift by leveraging the cluster types, distribution keys, sort keys, and by de-normalizing the data.
Technologies: Business Intelligence Development Studio, Redshift Spectrum, Identity & Access Management (IAM), SSAS, SSRS, SQL, Redshift, EMR, AWS Kinesis, AWS S3SQL Server and SSIS Developer
2012 - 2015Saibber- Led the offshore development team, acting as a technical mentor for developers.
- Helped formulate estimates and timelines for project activities and set related goals.
- Provided an architecture solution that was reusable, maintainable, and scalable.
- Created an ETL Design for splitting data with multiple values into normalized tables and designed an SSIS template to capture the package's execution events.
- Designed SSRS Report Templates and created SSRS Audit Tables.
- Scheduled the SSRS reports by using SQL-RD.
- Migrated Ab Initio graphs to SSIS Packages and Cognos reports to SSRS reports.
Technologies: SAP BusinessObjects (BO), Business Intelligence Development Studio, SQL Server Reporting Services (SSRS), Cognos 10, SQL Server Integration Services (SSIS), ETL, MDX, T-SQL, SQLMS SQL Server Developer
2011 - 2012BA Technolinks- Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
- Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins, and created indexes wherever necessary.
- Designed and implemented ETL processes with SSIS packages using heterogeneous data sources.
- Created different parameterized reports and worked on all types of report types such as tables, matrices, charts, sub-reports, and more.
Technologies: Windows Server 2005, Business Intelligence Development Studio, SQL Server Reporting Services (SSRS), Microsoft Excel, ETL, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), MDX, T-SQL, SQLBI and SQL Developer
2003 - 2010Techve Solutions PVT- Created tables, views, complex stored procedures, and indexes.
- Wrote complex SQL statements, custom T-SQL stored procedures, and triggers.
- Designed the production deployment system for configuration files.
- Worked on performance tuning by unblocking transformations.
- Generated multiple enterprise reports and included various reporting features such as groups, drill downs, drill through, sub-reports, navigation reports, and more.
- Maintained the physical database by monitoring performance and optimized SQL queries for maximum efficiency.
Technologies: Windows 98, Visual Studio 2005, SQL Server Analysis Services (SSAS), DTS, T-SQL, SQL Server 2000, Windows Server 2003, Microsoft Excel, Microsoft Access, SQL